I have a simple Crosstab. 1st column is date, 2nd column is total sales. I've added "Calculated Member" for 3 additional rows to determine the overall Minimum, Maximum and Average. I would like to suppress all but the last 3 rows. I'm assuming there is a way to go into "Format Crosstab", select suppress, and then enter some code into the formula box. However, I've tried a couple things, I'm not sure how to access the 'number of rows' in the crosstab, or how to access the "calculated member header" (which I could also use to determine which should not be suppressed)
Thank you in advance.