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.