# Qlik Sense App Development

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
New 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
Highlighted
MVP

## Re: Calculate % and difference in pivot

May be try this

``Sum(Measure)/Before(Sum(Measure))``
Highlighted
New Contributor

## Re: Calculate % and difference in pivot

Unfortunately, no...

Highlighted
MVP

## Re: Calculate % and difference in pivot

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

Highlighted
New Contributor

## Re: Calculate % and difference in pivot

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.

Highlighted
MVP

## Re: Calculate % and difference in pivot

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?

New Contributor

## Re: Calculate % and difference in pivot

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

## Re: Calculate % and difference in pivot

Use it as a measure and not dimension 🙂

Highlighted
New Contributor

## Re: Calculate % and difference in pivot

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

Highlighted
MVP

## Re: Calculate % and difference in pivot

Just use minus instead of divide