none
WEIGHTED AVERAGE CALCULATION USING MDX

    Question

  • Hello,

    I have Year, Model as my dimensions and Price, Units as my base measures. Now I have to derive a calculated measure Sales Amount at differnt drill down and roll up levels of cube. As in the image if we browse data with year and model level price will 5 and 10 respectively. If I remove model from browsing then price will be rolled up to sum which is wrong. I need it as weighted average like SUM(Price*Units)/Sum(Units).

    MDX to achieve this will be appreciated. Thank You in advance

    Best Regards,
    Sunil BI

    • Edited by Sunil BI Friday, September 20, 2013 4:22 AM BI
    Friday, September 20, 2013 4:20 AM

Answers

All replies