Hi All,

I need to calculate adjusted Revenue based on Total Revenue - Tax - COGS.

But my Tax/COGS are based on Product Types, Partners, etc...

e.g.

Tax COGS

Partner 1 10% 5%

Partner 2 5% 10%

Partner 3 5% 0%

............

My questions are as follow:

1. Is this kind of calculation best done in MDX or TSQL?

I have about 280K rows per month, and 28 calculations per row (e.g. c= a x b is 1 calculation, then d = c * 0.1 is another), so about 8 Million calculations. It's done using Excel 2010 currently.

2. How do I deal with zero or empty cell, will MDX speed up the performance?

3. How do I do this kind of calculation in MDX? I don't know how to setup
dimensions
with Calculated Measures.

The books I have seen so far shows me easy calculations like [Measures].[Total Sales] - [Measures].[Discount] but each combination of Partner/Product

**View Complete Post**

## Calculated measures, calculated cells, and custom rollups issue