% calculation at subtotal level and difference calculation

[FAA9]

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 

[v-jingzhang]

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]

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.