2 Replies Latest reply: Sep 24, 2012 1:50 PM by prabhatmandwani RSS

    Drill Down Question

      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.