Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Use second formula (%)
Sum(STOCK_INVOICE_VAL_IAS_SIM_EUR)/sum(total <PeriodCleared>STOCK_INVOICE_VAL_IAS_SIM_EUR)
Use second formula (%)
Sum(STOCK_INVOICE_VAL_IAS_SIM_EUR)/sum(total <PeriodCleared>STOCK_INVOICE_VAL_IAS_SIM_EUR)