This discussion is archived
0 Replies Latest reply: Jan 22, 2013 1:44 AM by 980436 RSS

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

980436 Newbie
Currently Being Moderated
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


Thanks,

Lakshmi kanth

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points