# App Development

Announcements
April 22, 2PM EST: Learn about GeoOperations in Qlik Sense SaaS READ MORE
cancel
Showing results for
Did you mean:
Contributor

## Calculate % and difference in pivot

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.

9 Replies
MVP

May be try this

``Sum(Measure)/Before(Sum(Measure))``
Contributor
Author

Unfortunately, no...

MVP

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

Contributor
Author

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.

MVP

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?

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

Use it as a measure and not dimension 🙂

Contributor
Author

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

MVP

Just use minus instead of divide