It can Achieve by making parameter & pass this parameter in to sheet.
1- Make Calculation for Share
2- Make Calculation for Price
3- Make Parameter of the name Share & Price for selection
4- Make Calculation
[Share] = [Parameter]
[Price] = [Parameter]
5- Pass above Calculation in Filter with yes
6 Use Parameter as a filter to chose Share or Price
Still Stuck, Plz Let me know
Not sure I fully understand the question
Table calculations work on the underlying table that supports the viz - each table calculation can work down - across - within a pane etc independent of the other table calculations - in nested table calcs you can open each individually and set the calc order and repeat
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
Sorry Alok didn't get your point#5.
Can you please share with me a table calculation use pane across and Table across which acts correctly based on parameter selection.
Will definitely try the logic and will get back .
The subtotals calculation are not correct.