Aggregating in Pivot table

[jpar0511]

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

[Kushal_Chawda · Accepted solution]

Use second formula (%)

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