Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
May be try this
Sum(Measure)/Before(Sum(Measure))
Unfortunately, no...
What was wrong when you used it? Would you be able to provide more information on where you want to see this?
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.
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?
Use it as a measure and not dimension 🙂
almost there I think, only the outcome doesn't make sense
Just use minus instead of divide