Pivot Table Month-over-Month

CyberCannon — Wed, 08 Dec 2021 14:03:45 GMT

Hello Everyone,

Hope you all are doing well and are getting ready for the holiday's! I've come across an issue that I have been trying to program for the past day or two, and just cannot wrap my head around it. Basically, I am trying to create a month-over-month and year-over-year pivot table, but do not want to use my existing (Below) function due to this not being 100% accurate.

I've tried using Lookup and conditional Sums - hopefully it is just a syntax error. My table looks like this:

Month	Previous Month	Quantity (=sum(DailyQuantity)	MoM
Dec 2021	Nov 2021	55	189%
Nov 2021	Oct 2021	29	64%
Oct 2021	Sep 2921	45	-

To calculate Month-over-Month, I want to use the Quantity of Dec 2021 and divide by the Quantity of Nov 2021 (55/29=189%)

Do y'all have any other ideas that I can try looking at?

Thanks and have a great day!

-Cannon

topic Pivot Table Month-over-Month in QlikView

Pivot Table Month-over-Month