topic Re: Calculate % and difference in pivot in App Development

Calculate % and difference in pivot

Vervoort — Fri, 16 Aug 2019 11:33:15 GMT

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.

Re: Calculate % and difference in pivot

sunny_talwar — Fri, 16 Aug 2019 11:35:36 GMT

May be try this

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

Re: Calculate % and difference in pivot

Vervoort — Fri, 16 Aug 2019 11:42:49 GMT

Unfortunately, no...

Re: Calculate % and difference in pivot

sunny_talwar — Fri, 16 Aug 2019 11:51:08 GMT

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

Re: Calculate % and difference in pivot

Vervoort — Fri, 16 Aug 2019 11:54:04 GMT

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.

Re: Calculate % and difference in pivot

sunny_talwar — Fri, 16 Aug 2019 11:56:53 GMT

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?

Re: Calculate % and difference in pivot

Vervoort — Fri, 16 Aug 2019 12:06:50 GMT

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

Re: Calculate % and difference in pivot

sunny_talwar — Fri, 16 Aug 2019 12:10:41 GMT

Use it as a measure and not dimension 🙂

Re: Calculate % and difference in pivot

Vervoort — Fri, 16 Aug 2019 12:21:18 GMT

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

Re: Calculate % and difference in pivot

sunny_talwar — Fri, 16 Aug 2019 12:26:04 GMT

Just use minus instead of divide