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