# Qlik Sense App Development

Announcements
See why Qlik is recognized as a Leader for the 10th year in a row – and discover how Qlik can help put your business in the lead. Get Report
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?

Highlighted
New Contributor

## Re: Calculate % and difference in pivot

It says, invalid dimension
=Sum(Subcategorie)/Before(Sum(Subcategorie)) 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