Hey all, I have a pivot table that has three report filters (City, Username, Payment Type), three Row Lables (Order ID, Receipt Code, Item Description), and three summed values which are the column labels (Quantity, Unit Cost, Total).
By using the report filters and the row lables (which have filters for each of the three) you can find whatever data you want in a certain criteria, obviously. What I want to know is there a way to list what a user is filtering by in a header or title page of some kind or something similiar?
Example: User filters by City = Chicago, Toronto, New York City, Boston, Miami, Lincoln; Payment Type = Check; Order ID = 1000 - 1010. So for a header with the listed filters I would want to see City: Chicago, Toronto, New York City, Boston, Miami, Lincoln; Payment Type: Check; Order ID: 1000, 1001, 1002, 1003, 1004, 1005, 1006, 1007, 1008, 1009, 1010 (or some easier way to list the order id's).
Having only worked with pivot tables for a short while I'm have no idea how to do this or if it can be done. I know that for the Report filters it lists the items in the filter box if there is only one or it says multiple items otherwise (or All).