Ignoring Fields w/ GETPIVOTDATA

Hello everyone,

Looking for some help with Getpivotdata.

I have a pivot table that aranges data into a heirarchy by level. Essentially, my data table starts with 8 columns titled Level 1, Level 2, Level 3, etc. Each row has the same value in the Level 1 column, and is then divided up into groups using the remaining level columns. The data is specifically designed to work in a pivot table, and it does this nicely. However, I need to show the data differently than how it comes out of the system, and to do this I've created a worksheet that instead uses a "bridge" pivot table and then GETPIVOTDATA to call up the figures. My goal is to create a dynamic template where any user could input the correct Levels and drill down to the desired level of detail within the data. The problem is that each level is a column/field, so a different GETPIVOTDATA formula is required to call upon a lower level of detail. I'm looking for a way to write one, consistent formula that will adjust for how many levels of detail a person would like to see. I know I could string together IF/ISBLANK statements to accomplish this, but I'm looking for a simpler and more concise solution. Please do let me know if the attached spreadsheet does not clearly show the problem I'm describing, or if additonal description is necessary. Any help would be wonderfully appreciated!

Thanks so much!GetPivotData_Problem.xlsx

Hello,

Anyone have any ideas?

97 views, but no comments.... Looks like we're stumped on this one!

mlj61289 I believe that people didn't understand where you are trying to get or because you actually already gave the solution " I could string together If/ISBLANK".
The truth is that the Pivot table you have already is pretty simple to use... If you are trying to reinvent the wheel to create a Pivot table with another format it doesn't add anything that currently exists.
Just my thoughts...
Kind regards,
D.