Hi
I'm creating pivots for monthly data, each extract of monthly data in it's own workbook. I then create a pivot from that data. In one workbook each row field has a filter arrow next to it allowing filtering of that field, but in my other workbook the first column has a field called row labels with a drop down and in that drop down another dropdown option for selecting what row label you want to filter by. When you click on the down arrow there is all the row labels and when you select one it gives you the list of data for that row label.
How is one different from the other with regard to the filtering layout and how can I find out where to manipulate these options?
thanks
G
I'm creating pivots for monthly data, each extract of monthly data in it's own workbook. I then create a pivot from that data. In one workbook each row field has a filter arrow next to it allowing filtering of that field, but in my other workbook the first column has a field called row labels with a drop down and in that drop down another dropdown option for selecting what row label you want to filter by. When you click on the down arrow there is all the row labels and when you select one it gives you the list of data for that row label.
How is one different from the other with regard to the filtering layout and how can I find out where to manipulate these options?
thanks
G
