on 12-16-2021 5:38 PM
Consider the Table below:
Sno Amount Status Date
1 50 Not ok 01/04/2020
2 100 Ok 02/01/2019
3 150 Ok 01/04/2020
4 200 Ok 01/04/2020
I want a crosstab table in webi report like
2020 Apr Not ok Ok
50. 350
2019 Jan 100
Then i can make the graph on basis of Status and Amount. 350 is sum of 100 and 200 as they belong to same month.
I have got the table format but not able to get the entry of 50 and 350, 100.
Kindly suggest.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.