# Qlik Sense App Development

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
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 MVP

## Re: Calculate % and difference in pivot

May be try this

``Sum(Measure)/Before(Sum(Measure))``
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?

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. 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)) MVP

## Re: Calculate % and difference in pivot

Use it as a measure and not dimension 🙂

New Contributor

## Re: Calculate % and difference in pivot

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

## Re: Calculate % and difference in pivot

Just use minus instead of divide