Is it possible to return the values of each column visible in a filtered pivot table?
I have a PT set up that holds a column of data called 'Type' which is a text string.
After filtering the PT down using the PT filters I have a drop down that gives me all the options that are in the data but is only showing the options in columns where there are totals due to the filtering.
I need to loop through these visible column descriptions (So the data column header is 'Type' but the column headers will be Type 1, type 2, etc) to return the totals.
The raw data contains Type 1 to Type 10 but after filtering I can only see Type 1 to Type 4 in the PT so I need to get the column name of each of these and also the total for the 'Type #'
TIA
I have a PT set up that holds a column of data called 'Type' which is a text string.
After filtering the PT down using the PT filters I have a drop down that gives me all the options that are in the data but is only showing the options in columns where there are totals due to the filtering.
I need to loop through these visible column descriptions (So the data column header is 'Type' but the column headers will be Type 1, type 2, etc) to return the totals.
The raw data contains Type 1 to Type 10 but after filtering I can only see Type 1 to Type 4 in the PT so I need to get the column name of each of these and also the total for the 'Type #'
TIA
