Hi, I am using Microsoft Data Analyzer and am using one of the "pre-built" MDX (offered by Data Analyzer) to find the %age. The MDX statement for %age looks like below in Data Analyzer: Length measure/sum(Members in filter for current dimension,Length measure)*100 I am trying to instead use a calculated measure on the server (for %age) rather than using Data Analyzer's solution - which is working fine and giving correct results but is slow. Assuming that my Length measure is based on a measure called 'TotalSales' how do I convert the rest of the MDX; especially the following part: "SUM(Members in filter for current dimension,Length measure)" so that I can define a calculated members on my cube. I hope my post is clear and will be very grateful for your help. Many TIA.