Share % in pivot table

[george456]

Dear Community

I need some assistance with the below:

(SUM({<CurrentPer={1}>}[MAT VALUE]) -SUM({<PriorPer={1}>}[MAT VALUE]))

This part of the syntax works perfectly. I now want to express the above as a % of the respective Total Month 

If I use the function Total as below I get the wrong output:

(SUM({<CurrentPer={1}>}[MAT VALUE]) -SUM({<PriorPer={1}>}[MAT VALUE]))/

(SUM(total{<CurrentPer={1}>}[MAT VALUE]) -SUM(total{<PriorPer={1}>}[MAT VALUE]))

Can you help please

Regards

[martinpohl · Accepted solution]

this

(SUM(total{<CurrentPer={1}>}[MAT VALUE]) -SUM(total{<PriorPer={1}>}[MAT VALUE]))

would give you the total (also the total for all months)

so edit to

(SUM({<CurrentPer={1}>} total <yourMonthfield> [MAT VALUE]) -SUM({<PriorPer={1}>} total <yourMonthfield> [MAT VALUE]))

Regards

[george456]

Thanks. Perfect