Hello I have a pivot table which shows below data which is based on percentage
TX - 20%
MD - 20%
NY - 30%
CA - 10%
RI - 20%
Total - 100%
Then I added a slicer to my pivot table. On the slicer when I select a specific state then the data becomes like below
TX - 100%
Total 100%
How can i keep the data static - where is shows - TX - 20% by selecting on slicer. Please help. Thanks
Bookmarks