Sum

[deepakqlikview_123]

Hello Team,

Can you please suggest how to make sum in pivot table  as for highlighted data as shown in attachment.

Thanks,

[#2]

go to Object Properties > Expressions and tick Full Accumulation

[deepakqlikview_123]

Hi Bertrand,

Thanks for reply.

Tick full accumulation option is disabled in Pivot table.

thanks

[jagan]

Hi,

Try Above()

=RangeSum(Sum(Sales), Above(TOTAL Sum(Sales), 1))

If the above expression not working then attach some sample file.

Regards,

Jagan.

[deepakqlikview_123]

Hi JaganMohan,

PFA.

For July 1 data is 161

For july 2 200

Then in july 2 cell =July 1 data + july 2 data =361

July 3 cell=

July 1 data + july 2 data + july 3 data

Thanks

[deepakqlikview_123]

Hi Manish,

Thanks for reply.

Here is solution.

Below is formula

=RangeSum(Alt(Before([Count YTD]), 0), sum(Count))

Here Count YTD is expression name but I am not able to undershand how it works.

Thanks

[jagan]

Hi,

You can refer one Expression in another expression by giving in [], the second expression uses the first expression. Also you can Column(1) for first expression, Column(2) for second. etc.,

Regards,

Jagan.

[jagan · Accepted solution]

Hi,

Please find attached file solution.

Regards,

Jagan.

[deepakqlikview_123]

Thanks Jagan,

I t is perfect.