How to calculate % using calculated Member

Last Post 22 Mar 2007 09:00 PM by SQLUSA. 1 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
wkenny
New Member
New Member

--
20 Jan 2006 04:01 AM
Hi all,

My problem is finding the corrrect functions (MDX) to create the
following report;

Here are the cube details;

Dimensions: Store, Products
Measure: Total Sales

The desired output is;
Products
------------------------------------------------
Store X Y Z
---------------
Downtown 500 10% 70% 20%
East-End 200 50% 15% 35%
West-End 100 30% 40% 30%
North 200 65% 5% 30%
Total 1000

If you have any thoughts or examples, it would be appreciated.
SQLUSA
New Member
New Member

--
22 Mar 2007 09:00 PM
You can just calculate % using regular arithmatic expression e.g. a/b.

Biggest decision is to multiply by 100 or not.

Kalman Toth
SQLUSA: http://www.sqlusa.com

You are not authorized to post a reply.

Acceptable Use Policy