Tuesday, November 13, 2012

How to make summary on multiple measures in a crosstab

Please see the following screenshot, where three measures are organized as parent child relationship.

Note that the total level measure can be any aggregations, such as total, average and calculation, as all measures are inherited from raw measures. Actually, such a report is very easy to design. Please download report specification for review in detail.

Create a basic crosstab with structure below

Highlight region and then click auto summary, aggregate function is applied

Drag summary from bottom to top

Highlight Revenue, Cross Profit and % Margin and copy them under Summary

Change summary as text “All regions” and format % and currency. Run it to generate report as above.

No comments:

Post a Comment