Hi,
I have a pivot table that lists 67 stores by their Region and State and respective sales for each store. I am using slicers to filter the data by Region and State. I also have a formula within the table that ranks the stores by their sales. So, when all slicers are unfiltered the results give me the stores ranked on a national level from 1 to 67. However, when using the slicer to filter on a specific state, the ranking formula re-ranks the stores within the state and does not retain their nationally ranked number. How can I retain the stores national ranking when using the slicer?
Thanks,
I have a pivot table that lists 67 stores by their Region and State and respective sales for each store. I am using slicers to filter the data by Region and State. I also have a formula within the table that ranks the stores by their sales. So, when all slicers are unfiltered the results give me the stores ranked on a national level from 1 to 67. However, when using the slicer to filter on a specific state, the ranking formula re-ranks the stores within the state and does not retain their nationally ranked number. How can I retain the stores national ranking when using the slicer?
Thanks,