DallasAggie
Programmer
Hiya all.
I hae a crosstab that shows sum of tickets in the body, sliced by year. Is there a way to suppress zero's?
EX:
2003 2004
---- ----
Q1 20 15
Q2 25 11
Q3 18 0
Q4 16 0
The reason I want them suppressed is because I have a line chart based on this crosstab, but don't want the zero's to be plotted.
I took the advice from another post about using 'Advanced' Vs. crosstab chart, but that didn't work cause I am using the 'Subdivided by' feature.
Any assistance would be appreciated.
Cheers.
Robert Andrade
The Boeing Company - Integrated Defense Systems
I hae a crosstab that shows sum of tickets in the body, sliced by year. Is there a way to suppress zero's?
EX:
2003 2004
---- ----
Q1 20 15
Q2 25 11
Q3 18 0
Q4 16 0
The reason I want them suppressed is because I have a line chart based on this crosstab, but don't want the zero's to be plotted.
I took the advice from another post about using 'Advanced' Vs. crosstab chart, but that didn't work cause I am using the 'Subdivided by' feature.
Any assistance would be appreciated.
Cheers.
Robert Andrade
The Boeing Company - Integrated Defense Systems