So I got rid of the Concatenate and tried Looks good so far … So I added the=INDIRECT and got a REF# error. Without the “=INDIRECT” part it produces the correct formula … I think I’m almost there, but I am still getting errors…maybe it’s just not possible? I hope that makes sense, and Thanks again for your help RomperStomper I know ignore is not an option I am just trying to show that I don’t want Excel to do anything but also don’t cause an error.
If(scenario = 2, GETPIVOTDATA("ItemsSold",INDIRECT($Q$1), “Product Line”,AA2,”ProdType”,AA3),etcĪnd so the formula grows to accommodate all of the combinations. If(scenario = 1, GETPIVOTDATA("ItemsSold",INDIRECT($Q$1)), '=GETPIVOTDATA("ItemsSold",INDIRECT($Q$1), “Product Line”,” Soccer Equip”,”ProdType”,”Balls”) If the user selects All Zones, Soccer Equip, Balls the formula would look like this '=GETPIVOTDATA("ItemsSold",INDIRECT($Q$1)) So If the user selects All Zones, All Product Lines, All Prod Types the formula would look like this So Q1 will have a value of “Tables$A$1”, or “Tables!$F$1”, etc I have some logic that decides which table has the data I need and the table location is in cell Q1. I have to use several pt because of the different rollups needed. Some by month, some by YEAR, some by product type, some by product line, etc. I have several pivot tables that provide this information in several different formats. AA1 - Zone (North, South, East, West, All)ĪA2 - Product Line(Soccer Equip, Baseball Equip, Football Equip, …, All)ĪA3 - Product Type (Balls, Protective Gear, Shoes, …, All)
0 kommentar(er)
