Database Reference
In-Depth Information
3. In the PivotTable field list in the row box click on the arrow beside the
Sales
Amount
measure and choose
Value Field Setting
.
4. Change the name to
Pct of Grand Total
.
5. Now you can add
Sales Amount
a second time to the PivotTable.
The preceding procedure actually does not create a MDX calculated measure, but it
can be used to achieve the same thing as a calculated measure would do.
Calculated members
The third advanced function in Excel 2013 that we will look at is the possibility to cre-
ate calculated members within a dimension. Follow the given steps to create a new
member within the product hierarchy:
Search WWH ::
Custom Search