MyTable is as follows:
I want to list the table along with each persons percent of the total
Revenue. How can I do this?
Everyone here speaks SQL; some are more fluent, others less. When
describing your SQL object (table, etc.), do so in the language that we
all understand - SQL, not English. It makes it easier to understand
your issue and makes it more likely that you will get the assistance
that you are asking for.
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
I have a measure: [NoOfCases], and a dimention: [Departments]
I want to build a calculate member: [PercentOfTotal], that will be the value
of [NoOfCases] for a specific department divided by that value for all
Can yo please provide me the MDX syntax?