In the web report when we have pivoted worksheet we would like to have a way to create custom calculation between two worksheet without having to specify the pivot name column.
As an example,
If we got the Quantity Pivoted by year we will get the column Worksheet1_2019_Quantity, Worksheet1_2020_Quantity for the first Worksheet and for the second worksheet Worksheet2_2019_Quantity, Worksheet2_2020_Quantity.
So instead of adding a calculation for each column (Worksheet1_2019_Quantity -Worksheet2_2020_Quantity) without knowing if extra years will be added eventually we would like to be able to simply do (Worksheet1_Quantity - Worksheet2_Quantity) and it would affect all the pivoted values.