Forum Discussion

FAA9's avatar
FAA9
Frequent Visitor
3 years ago

% calculation at subtotal level and difference calculation

Hi,

 

I need to see the subtotals at subtype-region level and calculate their difference vs one particular region. How do I do that?
All the columns below from W onwards are measures 

 

 

Need Help

2 Replies

  • v-jingzhang's avatar
    v-jingzhang
    Community Support
    3 years ago

    Hi FAA9 

     

    Can you please paste some dummy data and measure formula of X & Z? In addition, where do you want to display the Diff % value (96-83)?

     

    Best Regards,
    Community Support Team _ Jing

    • FAA9's avatar
      FAA9
      Frequent Visitor
      3 years ago

      Hi,

      X & Z are basically being calculated at row level (lowest granularity) based on prior weeks data & summing up of inventories at different warehouses. They are a combination of other measures.
      I wish to be able to see the diff value in the table on the right. 
      I was able to use the pivot table calculation of show "difference vs Region" for Z vs X measure to show the difference by using UK as the base region, however, that difference is only visible if I have UK in the table and UK field is expanded. 
      I want to be able to show that difference even if UK is not part of the selection at type and subtype level.