Problem with cumulative sum in pivot table when change sorting

[JLB]

Hello, 

I need your help regarding the problem below : 

I created a pivot table with :

-1 dimension : Source Loc Country (=Country code) 

- 2 mesures :

   Spend by Country => Expression = Sum([Spend In €]) 

   Cumul Spend By Country => Expression = RangeSum(Above(TOTAL sum([Spend In €]),0,Rowno(TOTAL)))

So far, it works. 

But when I want to sort by 'Spend by country' (desc) instead of 'Source Loc Country' (alpha asc), I have this 2 second pivot table : 

What can I change to have a cumulation according to the 'Spend by country' and not the 'country code' ?

Thanks for your help!

JL

[edwin]

i think you are supposed to use before and not above for pivots.  look for a prior posting re this

[JLB]

Hi Edwin,

I did it before, and it does not work with 'before'.

[JLB · Accepted solution]

Hi, 

One of my colleagues found the solution. It was enough to add the formula 'Sum([Spend In €])' in the sorting by expression of 'Source Loc Country'