This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I am not sure I quite follow the logic at this stage, would you be able to give a bit more context. With each Filter are you looking to just take the Column you filter as well as the 'Grand Total'? You can then subtract the Column you have filtered from the 'Grand Total' in order to get 'G (Rest All)'.
Unable to understand the query as column G (rest all) is where there is disconnect. can you explain the scenario in detail. As G & grand total there is confusion. Also, wondering filtering A, how does G values increased by 10?