HI, I want to calculate the difference between Jun and Jul figures of ( 0 - 90 ) & ( 91 - 180 ) & ( > 181 ).
Results should be in Pivot or Stright table.
Formula = Last Month Position - Current Month Position.
Jun ( 0 - 90 ) - July (0 - 90 )
Jun ( 91 - 181 ) - Jul ( 91 - 181 )
Jun (> 181) - Jul (>181)
Jul Table
| 0 - 90 | 91 - 180 | > 181 | Total Branch |
| USA | xxxxx xxx | xxx xxxx | xxxxxxx | xxxxxxx |
| UK | xxxxx,xx | xxxxx | xxxxxxx | xxxxxx |
| UK | xxxxxxxx | xxxxxxx | xxxx | xxxxxxx |
| Grand Total | xxxxxxxxx | xxxxxx | xxx | |
Jun Table
| 0 - 90 | 91 - 180 | > 181 | Total Branch |
| USA | xxxxxxx | xxxxxx | xxxxxx | xxxxxxxxxx |
| UK | xxxxxxx | xxxxx | xxxxxx | xxxxxxxxx |
| UK | xxxxxx | xxxxx | xxxxxxx | xxxxxxxxxx |
| Grand Total | xxxxxxxx | xxxxxxxx | xxxxxxxxxx | |
Diffrence Table
| | Value | % |
| JED | xxx | xx% |
| KHO | xxxxx | xx% |
| RIY | xxxxx | x% |
