My piovt has LOCATION and PRODUCT for the rows and REVENUE for Value.
My goal is to create a new MDX Calculated Measure show each PRODUCT its % of it LOCATION REVENUE Total. Therefore, I created separate "Product Rev" & "Total Product Rev" measures....the a "% of Total" measure where [Product Rev] / [Total Product Rev]. This would be similar to a "% of Parent Total".
My prob is once I add the new "% of Total" MDX Measure to my pivot table I do not get the expected 100% on the subtotal line. All of the individual product % are there and add up to the 100%....but nothing shows for the subtotals....in fact, they are actually BLANK.
Any ideas.
Thanks
My goal is to create a new MDX Calculated Measure show each PRODUCT its % of it LOCATION REVENUE Total. Therefore, I created separate "Product Rev" & "Total Product Rev" measures....the a "% of Total" measure where [Product Rev] / [Total Product Rev]. This would be similar to a "% of Parent Total".
My prob is once I add the new "% of Total" MDX Measure to my pivot table I do not get the expected 100% on the subtotal line. All of the individual product % are there and add up to the 100%....but nothing shows for the subtotals....in fact, they are actually BLANK.
Any ideas.
Thanks
