Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All.
I have an issue trying to suppress the first column in a pivot table.
In the attached application, I have two charts:
Quarter Totals - Show totals for the selected quarter (Tracking Period calendar object) and 3 previous quarters. This is working correctly.
Quarter Differences - Show the differences between the quarter and the previous quarter. In this chart, I want to show these values for current quarter and 2 previous quarters. For example, if Tracking Period 31/01/2013 is selected, I only want to see 2012-Q3, 2012-Q4 and 2013-Q1 on this chart.
My question is how can I suppress the first column in the Quarter Differences chart? If Tracking Period 31/01/2013 is selected, I want to suppress 2012-Q2.
I am using QV10 SR2.
Thanks,
John.
See attached example.
That works.
Thank you very much Gysbert.