Thursday, May 5, 2011

Average of the Grand Total in the Pivot Table

1) Click on the fact in the Measures section of your pivot table.

2) Duplicate the layer.

3) Click on the duplicate layer and change the Aggregation Rule to Average.

Now you have the sum of the measures and the averages.

Until Next Post...Keep Smiling ;)

No comments:

Post a Comment