I am trying to get the grand totals to display in a new grand total column when the dimension is selected from a filter. for instance i have attached a spreadsheet that has region, state, measure 1 and measure 2. Measure 2 is the grand total of all the dimensions. I want to be able to select dimension( state ID 1,2) and be able to get the grand totals for each dimension displayed on measure 2 tab.
Do you have a sample .twbx showing the work that you have done? The spreadsheet provided is nice but seeing what you are trying to do in a workbook would greatly assist in seeing the issue encountered.