Pivot Table - Sum of a calculated column

[Werwolfli]

Hello

I have the following Pivot Table

I have 1 Dimension - called "Standort".

The Column "Total Transaktionspreis" is a calculated column. 

--> Count({<WorkitemSource = {"*abcd*"}>} distinct WorkitemID)

The Column "Anteil Infrastruktur" is a percentage value.

Now i need to have the following value in the last column "Anteil Infra CHF":

The sum of all values in the column "Total Transakationspreis" * the percentage value.

How do i get the sum of all values in the column "Total Transaktionspreis" that i can to the calculation for the "Anteil Infra CHF column"

Thank you for you help.  

[rubenmarin]

Hi, you can use aggr the split the calculatins by the different dimensions and use a sum as an aggregation function like:

Sum(Aggr(Count({<WorkitemSource = {"*abcd*"}>} distinct WorkitemID)*[Anteil Infrastruktur],Standot))

[Werwolfli]

Thx for your support.

Now I have an issue to calculate the % value in the column "Anteil Infrastruktur"

There I need the % of "Total Transaktionspreis" of the sum of "Total Transaktionspreis"

So "Total Transaktionspreis" / Sum of "Total Transaktionspreis"

How can i do this?

[rubenmarin]

Hi, try with:

Count({<WorkitemSource = {"*abcd*"}>} distinct WorkitemID) / Count(TOTAL {<WorkitemSource = {"*abcd*"}>} distinct WorkitemID)