Forum Discussion

FAA9's avatar
FAA9
Frequent Visitor
4 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
v-jingzhang's avatar
v-jingzhang
Icon for Community Support rankCommunity Support
4 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
    4 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.