Hi,
I have a pivot table set up which is showing me all spend by account, Cost center, quarters and then I can drill down to line item for more detail. Works great when I want to filter for a 1,2 or 3 cost centers.
But it fails when I want to look up multiple cost centers. My filter has over 100 unique cost centers. When I need to filter to multiple cost center, I have to go in and tick mark each cost center. sometimes I am looking for details with more than 30 cost centers. Its very annoying to filter them each time. The Cost centers I look for are in no particular range, the numbering is random.
I am sure there is a easy way of doing it which I am not aware of. Can someone please help.
TIA
I have a pivot table set up which is showing me all spend by account, Cost center, quarters and then I can drill down to line item for more detail. Works great when I want to filter for a 1,2 or 3 cost centers.
But it fails when I want to look up multiple cost centers. My filter has over 100 unique cost centers. When I need to filter to multiple cost center, I have to go in and tick mark each cost center. sometimes I am looking for details with more than 30 cost centers. Its very annoying to filter them each time. The Cost centers I look for are in no particular range, the numbering is random.
I am sure there is a easy way of doing it which I am not aware of. Can someone please help.
TIA