JimS
03-29-2013, 11:00 AM
I have been all over trying to learn how to use a non-continuous data range as the source for a Pivot Table but I cannot figure out how to make it work - perhaps it won't.
I have a large list of data that I would like to only point to a subset of this data, using a dynamic range name, and use it as the source for a pivot table.
I will ultimately use the main list to create several smaller subsets as the source data for several pivots.
I'm able to create a range name that points to the subset of data but I would like to include the data header row if possible.
I'm using Excel 2007.
In the attachment is an example of the data.
Thanks for any ideas...
JimS
I have a large list of data that I would like to only point to a subset of this data, using a dynamic range name, and use it as the source for a pivot table.
I will ultimately use the main list to create several smaller subsets as the source data for several pivots.
I'm able to create a range name that points to the subset of data but I would like to include the data header row if possible.
I'm using Excel 2007.
In the attachment is an example of the data.
Thanks for any ideas...
JimS