Good evening Guys and Girls
I have a pivot table that uses a dynamic range as its data source.
I do not always want all of the data in the range to be pivoted so I applied a filter to the data.
The dynamic range works fine but the pivot table uses all of the data on the sheet and not just the filtered data.
What am I doing wrong?
DO I need to use an advanced filter and copy the data to be pivoted to another sheet and use a dynamic range there?
I'm sorry but I'm off to bed now (22:45 GMT) and will probably dream about this problem so any help that you can give me will
be much appreciated for my health service project oh so near to completion.
Justin
I have a pivot table that uses a dynamic range as its data source.
I do not always want all of the data in the range to be pivoted so I applied a filter to the data.
The dynamic range works fine but the pivot table uses all of the data on the sheet and not just the filtered data.
What am I doing wrong?
DO I need to use an advanced filter and copy the data to be pivoted to another sheet and use a dynamic range there?
I'm sorry but I'm off to bed now (22:45 GMT) and will probably dream about this problem so any help that you can give me will
be much appreciated for my health service project oh so near to completion.
Justin