Hello all!
I have the following problem. I have CSAT (customer satisfaction) table, that compiles stores, months and their metric for each month. Stores are in the row field, months are columns.
I would like to sort, for each month, the bottom 4 (at the top) based on their CSAT score. The problem I have is that if I do this, it will only sort based on the first month. For example:
We have 8 stores. Stores 1-4 were the worst in the first month, so naturally they will be filtered by the pivot table. Next month, stores 5-8 are the worst, but the table will still only show 1-4 with their high scores.
Is there a work around this?
Cheers.
Bacon
I have the following problem. I have CSAT (customer satisfaction) table, that compiles stores, months and their metric for each month. Stores are in the row field, months are columns.
I would like to sort, for each month, the bottom 4 (at the top) based on their CSAT score. The problem I have is that if I do this, it will only sort based on the first month. For example:
We have 8 stores. Stores 1-4 were the worst in the first month, so naturally they will be filtered by the pivot table. Next month, stores 5-8 are the worst, but the table will still only show 1-4 with their high scores.
Is there a work around this?
Cheers.
Bacon
