Calculate percent change for multiple pivot table dimentions

dukane24 — Fri, 28 Sep 2018 20:38:22 GMT

Hello,

I have a pivot table that lists an amount for the year and month, and my objective is to calculate the month over month percent change, as well as the year over year percent change.

This is the expression I'm using to calculate the YoY change is as follows. Please note that I'm using the column label for this expression. The

"Amount"/Above("Amount")-1

The problem I'm having is with adding an expression for the MoM percent change. I have not found a way to create the expression referencing the Month dimension specifically. I'm sure there's probably a simple way to do this that I don't know about. If anybody could shed some light on this, it would be most appreciated.

Here is a sample of the layout of my pivot table:

Month	Year	Amount	YoY	MoM
Jan	2017	11,096,086
Jan	2018	11,410,464	2.83%
Feb	2017	7,854,102
Feb	2018	7,510,170	-4.38%

topic Calculate percent change for multiple pivot table dimentions in QlikView

Calculate percent change for multiple pivot table dimentions