cancel
Showing results for 
Search instead for 
Did you mean: 

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

former_member515644
Participant
0 Kudos

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.

Accepted Solutions (0)

Answers (1)

Answers (1)

ayman_salem
Active Contributor
0 Kudos

1- Define the following variables:

v_Date: =FormatDate([Date]; "yyyy mmm")

v_Amount: =Sum([Amount]) ForEach ([v_Date])

2- Use them in your tables and graphs instead of the [Date] and [Amount] dimensions.

...

hopefully that helps

ayman_salem
Active Contributor
0 Kudos

I hope the answer meets your needs. If it is okay with you, kindly accept and close the question