0 Replies Latest reply: Jan 18, 2018 6:30 AM by Mohammad Adnan Ansari RSS

    Weightage & Totals in drill down dimension

    Mohammad Adnan Ansari

      I am working on Retail Sales Data where we are analyzing the Item Categories with respect to customers (No of Invoices) who bought items with those categories.

       

      The Drill down dimension is : Item Category --> Item Class

       

      I am using standard master calendar:

       

      The below is the sales table format:

       

      Sales Invoice No

      Date

      Item Code

      Qty

      Sales

       

       

      The Item Master table is as below:

      Item Code

      Item

      Item Category

      Item Class

       

       

      I am using a simple table where I am showing for each Drill down category the weightage of customers;

      ie :

       

      Sum(aggr(  (No of Customers buying items in this category) / (Total No of Customers),  [Item Category]))

       

      Infact there is a requirement from the customer to show the totals of percentages. (and that could go beyond 100).

       

      Now when I drill down to Item Class; the figures are not correct. The table should show the weightage of customers of Item class with respect to all customers. (All classes in All Categories). whereas it just shows 100%.