Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

3 Year YTD Comparison ( +/- , %) in Pivot Table

I know this subject of year to date calculation is fairly beat to death, but I have not found anything that is really pointing me in the correct direction. 

I have a pivot table where I need to show Item #, Item Name in the rows section, and also showing years in the row section as well.

I have placed my measures in the columns, I made a measure for each month of the year and the 13th column being a YTD total of that rows year.  This part is working great!

My issue is I need to show an analysis of this in this format in columns 14 - 15 (similar to the attached jpg),  I cant seem to find a way to show the rows year YTD -  the previous rows YTD at the very least.

This is extremely easy to make in excel, but this is something that is going to be used heavily so I can't use excel as the solution to make these analytics.

Please let me know if anyone has a solution for this. 

1 Solution

Accepted Solutions
MarioCenteno
Creator III
Creator III

3 Replies
MarioCenteno
Creator III
Creator III

This article could help you.

Missing Manual - Above() and Below()

Anonymous
Not applicable
Author

This is exactly what I was looking for, thank you very much!

MarioCenteno
Creator III
Creator III

Your welcome