Calculate % and difference in pivot

[Vervoort]

Dear all,

Please find below a screenshot of the pivot i've got. I want to calculate the difference between 2018 and 2019 in absolute numbers and the in-/decrease of 2019 compared to 2018. 

[sunny_talwar]

May be try this

Sum(Measure)/Before(Sum(Measure))

[Vervoort]

Unfortunately, no... 

[sunny_talwar]

What was wrong when you used it? Would you be able to provide more information on where you want to see this?

[Vervoort]

Absolute difference, as a column after 2019.

So for line 1 BOM Mass Change it's 108-27=81 more increase.

And after the absolute number a column with % of the 81 difference/increase. 

[sunny_talwar]

Try this for Absolute Difference

Sum(Measure)-Before(Sum(Measure))

Not sure what you mean here?

"And after the absolute number a column with % of the 81 difference/increase. "

What is the difference between difference and increase?

[Vervoort]

It says, invalid dimension
=Sum(Subcategorie)/Before(Sum(Subcategorie))

[sunny_talwar]

Use it as a measure and not dimension 🙂

[Vervoort]

almost there I think, only the outcome doesn't make sense

[sunny_talwar]

Just use minus instead of divide