0 Replies Latest reply: Jan 22, 2013 3:44 AM by 980436 RSS

    sum of   net_price  column shows  4 folds to actual value in bi answers

      Hi All,

      I have created a drill down report .the column net_price ,net_cost are facts. my report hierarchy is promo_code,promo_name,transaction_id,promo_id. when do drill down report as below

      transaction_hierarchy net_cost net_price. But it shows 4 times of sum of net_price against promo_id in bi answers . i think it shows 4 folds because it has 4 levels .
      Please someone tell me how to get rid of above concern


      Lakshmi kanth