Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
john_duffy
Partner - Creator III
Partner - Creator III

Suppress column in a pivot table

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.

1 Solution

Accepted Solutions
Gysbert_Wassenaar

See attached example.


talk is cheap, supply exceeds demand

View solution in original post

2 Replies
Gysbert_Wassenaar

See attached example.


talk is cheap, supply exceeds demand
john_duffy
Partner - Creator III
Partner - Creator III
Author

That works.

Thank you very much Gysbert.