Thank you very much Zhouyi, this works Perfect!!!
There is one more problem for me if you don't mind can you please help on this?
I attached workbook and made few tabs.
There is a created calculated fields to calculate Profit% and Sales% and want I am trying to display on grand total for Company F1 is total percentage of Marketing, Misc and Other which is 92.12% instead of 97.37% and same thing for Sales like to display 61.10% instead of 79.99%.
One more thing there are multiple Company's, Region's and Corporate and I added these fields to the context but when I select multiple company's the percentages are changing for company F1 because the profit and sales percentages formula is calculating from grand total instead of individual company's total.
When you compare two screen shots the percentage values for factors for F1 company are changing for when I select multiple screen shots. But I want to keep the same for F1 even when I select multiple company's or regions or coporate
So, Finally I am expecting to display like this when I select multiple filters, in below screen shot the profit and sales percentages are calculating using company's total instead of grand total.
this formula works but doesn't display percentage values in Sales column and I like to include % values in sales column but total I want to eliminate Finance, HR and Sales
Workbook Test.twbx 22.5 KB