I have a chart to compare budget and sales by fiscal year, quarter , period , category and product id.
Drill down dimension is used for fiscal year, quarter , period , category and product id.
Sales $ expression is sum (price*qtyshipped)
Budget $ expression is sum (distinct (budgetquantity * budgetprice))
I selected the fiscal year 2013, quarter 2 and period 05 as selection. For a particular category , budget $ is shown incorrectly, but if I drill down to the product id level (i.e. by selecting category) it shows the correct values. I am unable to understand why the data is not summarized correctly at the category level.