I want to display a couple of percentages based on counts. My cube only
displays counts. I want one calculation that displays the "percentage of
all" and another one that is the "percentage of displayed" .

This is in essence of what I want:

[Percent of All] = [Measures].[Count] / [Total Rows in Cube?]
[Percent of Displayed] = [Measures].[Count] / [Sum of currently displayed
Measures.Count?]

Does anyone know how to do this?

Thanks,

Joe

The following does a "percent of parent", "percent of total" along the
Product Categories hierarchy in the Adventure Works DW database.

WITH MEMBER measures.pcntOfParent as ([Product].[Product
Categories].CurrentMember, Measures.[Internet Sales Amount])
/ (iif([Product].[Product Categories].CurrentMember.Parent is null
,[Product].[Product Categories].CurrentMember
,[Product].[Product Categories].CurrentMember.Parent),
Measures.[Internet Sales Amount]), FORMAT_STRING = "0.00%"
MEMBER measures.pcntOfTotal as ([Product].[Product
Categories].CurrentMember, Measures.[Internet Sales Amount])
/ ([Product].[Product Categories].[All Products], Measures.
[Internet Sales Amount]), FORMAT_STRING = "0.00%"
SELECT
{ Measures.[pcntOfParent], Measures.pcntOfTotal } ON COLUMNS
, {[Product].[Product Categories].Members} ON ROWS
FROM [Adventure Works]


Creating a "percent of displayed" measure is a lot more difficult to do
generically. You could look at the axis() function to try and figure out
what the users are querying, but it is easier to take the percentage
from a fixed point of reference.

--
Regards
Darren Gosbell [MCSD]
Blog: http://www.geekswithblogs.net/darrengosbell

In article <1150582359.533297.265910 (AT) g10g2000cwb (DOT) googlegroups.com>,
willrich33 (AT) yahoo (DOT) com says...