Database Reference
In-Depth Information
Case
When IsEmpty
(
[Measures].[Reseller Sales
Amount]
)
Then Null
Else ( [Reseller].[Reseller
Type].CurrentMember,
[Measures].[Reseller Sales Amount]
)
/
(
Root
(
[Reseller]
),
[Measures].[Reseller Sales
Amount]
)
End
3. Set the measure's Format String property to Percent , Associated Measure
Group to Reseller Sales , and NonEmpty Behavior to Reseller Sales
Amount . Save the database.
4. Next, to check the newly added calculation, launch Excel and create a pivot
table against the Adventure Works database. Choose the Reseller Sales
Amount and Reseller Type Percentage of Total measures as values and
the Reseller Type hierarchy on rows to see the following result:
Search WWH ::




Custom Search