Accumulation in Crosstable

Nolgath — Thu, 24 Oct 2024 07:11:41 GMT

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?

Re: Accumulation in Crosstable

brunobertels — Thu, 24 Oct 2024 08:10:10 GMT

try this :

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

regards

Re: Accumulation in Crosstable

Nolgath — Thu, 24 Oct 2024 08:43:03 GMT

Hello brunobertels,

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

Regards

topic Re: Accumulation in Crosstable in App Development

Accumulation in Crosstable

Re: Accumulation in Crosstable

Re: Accumulation in Crosstable