Hiding the Column Dynamically Using View Selector & Tracing Renamedviews

1.Select the required columns into criteria tab



2.Create the pivot tables for each dimension column as a row and exclude the remaining dimension columns.


Like above create 2 more pivot tables as Pivot Table 2 having Product as row and Pivot Table 3 having Fiscal Year as a row.
3.Add a view selector into the compound view.
4.Include all pivot views into view selector


5.Rename the pivot table view names into your own business words.

Then click OK. Do the same thing for pivot table 2 and 3.
like





6.The result will be at Dashboard as




Now
7.To know the renamed view which is actually coming from which pivot table view,you need to go again rename option in view selector view,and do like following


Cut/delete the name and click OK. Then it reverts the renamed name into actual pivot table view name .Like