Requirement

[deepakqlikview_123]

Hi all,

Please find attachment

As per requiremnet I need to show data in pivot table as

Field 2 data=feld 1 data+ field 2 data

Field 3 data=feld 1 data+ field 2 data + Field 3 data

Field 4 data=feld 1 data+ field 2 data + Field 3 data+Field 4 data

Can you please suggest what  would be the formula for this

Please find QVW file there are month wise days and on combination of month and day there is count of sales.

I need to show data like

Day1 data data=Day 1 data+ Day 2 data

Day 3 data=Day 1 data+ Day  2 data + Day 3 data

Day 4 data=Day 1 data+ Day 2 data + Day  3 data+Day 4 data

Thanks

[MK_QSL]

Please provide data in excel file or in sample apps.

[its_anandrjs · Accepted solution]

Please provide sample data otherwise you can achieve this requirement in the pivot tables.

[deepakqlikview_123]

Please find QVW file there are month wise days and on combination of month and day there is count of sales.

I need to show data like

Day1 data data=Day 1 data+ Day 2 data

Day 3 data=Day 1 data+ Day  2 data + Day 3 data

Day 4 data=Day 1 data+ Day 2 data + Day  3 data+Day 4 data

thanks

[deepakqlikview_123]

Hi anand,

PFA,Please suggest how to implement same in pivot table.

Thanks

[SunilChauhan]

Hi Deepak.

use rangesum(above(sum(Amountfield)),0,rowno(Total))  in expr

see the attched file

hope this helps

[deepakqlikview_123]

Hi Sunil,

Thanks for reply.

Currently my days are not rows I have taken them as a columns for same reason by using formula whatever u have mention I am getting sum for day 1 day2 only .

In this case can u plz suggest how to proceed,

Thanks