In my Crosstab I have the following rows:
Country, Product Line, Product Type, Revenue, Unit Price.
Revenue and Unit Price are nested after Product Type one below the other.
In the columns I have year.
I want to aggregate the Revenue and Unit Price by Average for each product line and place it after each product line.
How can I do this?
Hi,
Simply move the two measure values (Revenue and Unit Price) so they are nested below the Year column heading. Then select your Product Type row headings, press the Aggregate button on the toolbar, and choose Automatic Summary.
Cheers!
MF.