Aggregating in Pivot table

jpar0511 — Wed, 18 Dec 2019 09:27:06 GMT

Hello together,

I'm trying to aggregate data in a pivot chart.

My dimensions are PeriodCleared and Cluster.

As you can see the sum in the first column is working - but I can't get the total sum of each PeriodCleared in the second column. The Value is present - but only in Cluster 2.

In the final result I want the percentage of each Cluster according to the total period value.

First formula:

Sum(STOCK_INVOICE_VAL_IAS_SIM_EUR)

Second formula:

sum(aggr(sum(STOCK_INVOICE_VAL_IAS_SIM_EUR),PeriodCleared))

Any help is appreciated.

Thank you

Jörg

Re: Aggregating in Pivot table

Kushal_Chawda — Wed, 18 Dec 2019 09:36:36 GMT

Use second formula (%)

Sum(STOCK_INVOICE_VAL_IAS_SIM_EUR)/sum(total <PeriodCleared>STOCK_INVOICE_VAL_IAS_SIM_EUR)

topic Aggregating in Pivot table in App Development

Aggregating in Pivot table

Re: Aggregating in Pivot table