Skip to Content
0
Dec 16, 2021 at 05:38 PM

Total as per the Amount in the column monthwise in Webi report

92 Views

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.