Multiple Summaries by Months, YTD, and Prior Years
I've attached an excel spreadsheet with what I would like my qlikview chart to display, and I've also attached a picture of what I've already done - I'm using a pivot table with Month([QA Report Date]) as the dimension, and a few different summaries of fields as expressions... I'm just wondering if it's even possible to have a YTD column and previous years columns, along with the month columns I already have?
This seems like it will be extremely difficult to do (if it's even possible), so my thoughts were I would just have to create more than one chart? (It is preferred that no scripting be added).