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