Accumulation in Crosstable

[Nolgath]

Hello, I have a cross table like this:

//----------------------------------------------------------------------

Transposed:
crosstable (Fields, Value, 1)
Load
Trim(Month) as Month,
Trim(direct_sales_units) as "Direct Sales (Units)",
Trim(online_sales_units) as "Online Sales (Units)",
Trim(total_units) as "Total Units"

Resident [form_data_qvd];

//----------------------------------------------------------------------

I need to have a accumulation of each field according to Month. Month field has all months in caps like 'JULY', 'JUNE' etc.. I need the accumulation to be from 'JULY' to 'JUNE' as this is the fiscal year.

When I try to rangesum(above() in expression on the pivot table itself it gives me strange numbers.. how can I achieve a table like that but with accumulations instead?

[brunobertels · Accepted solution]

Hi 

try this :

rangesum(before(YourMesureHere,0,columnno()))

regards 

[Nolgath]

Hello brunobertels,

Tried that on my pivot table measure, works perfectly, thank you very much!

Regards