Cumulative Sum based on dynamic Ranking

[jorgie]

Hi to all,

I try to cumulative sum values based on calculated Rank in front end.

More specific, I have  value Rank( Sum ( if ( Sales>0, Sales ) ) ).

Based on the value of each row I want to have the cumulative sum. 

For example if rank is 3, must sum Sales for Rank 1, 2, 3.

The RowNo() read import sort and give wrong results in general.

Thank you in advance for your help

[jorgie]

like you said it works just fine but the in the table must have the specific named in expression field. In that case customer.

Just a question. I have pivot table that dimensions are material and month, and measure is count(customers). is this expression could work in set analysis? meaning like count customers that for the given expression value is >1.000.  Or a way to connect the materials table with the customers table that i use the complicated expression selecting the customers. 

Dont know just thinking at loud.

thanks for your help anyway!