Skip navigation

MDX Tip of the Month - 01 Jun 1999

A common business problem is determining percentage contribution to a group. For example, you might want to know what percentage of the total revenue of a product line a particular product contributed, or what percentage of growth of sales in a country by each region in that country contributed.

Here's one way to solve this problem: For each revenue/dimension combination you want to analyze, create a new calculated member. For instance, if you want to analyze \[Store Sales\] as a percent of a group in the Product dimension, create a member as in Listing A. Screen A shows the result set from this query.

TAGS: SQL Server
Hide comments


  • Allowed HTML tags: <em> <strong> <blockquote> <br> <p>

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.