Home > OLAP Calculation Templates > Share and Ranking > Share
![]() Previous |
![]() Next |
Calculates the ratio of the value of the current dimension member to the value of a selected member. Multiplying this fraction by 100 generates the percentage.
Share of measure measure (...) in hierarchy hierarchy of the dimension dimension as a ratio of { top of hierarchy | member's parent | ancestor at level level | member (...) }.
Multiply result by 100.
This calculated measure computes the percentage that each customer contributes to its parent in the Units measure.
Share of measure UNITS in CUSTOMER_MARKET hierarchy of the CUSTOMER dimension as a ratio of member's parent.
Multiply result by 100.
The Pct Share column shows the percentage that each market segment contributes to the total number of units sold.
Customer Parent Units Pct Share -------------------- ------ ------- --------- Reseller TOTAL 304415 54 Consulting TOTAL 250931 44 Government TOTAL 5756 1 Manufacturing TOTAL 4121 1 Education TOTAL 495 0 Total Customer null 565718 100