SOLVED

Help with adding data pulled in with Pivot Table. Is there a way to sum dynamic multiple cells?

%3CLINGO-SUB%20id%3D%22lingo-sub-3366254%22%20slang%3D%22en-US%22%3EHelp%20with%20adding%20data%20pulled%20in%20with%20Pivot%20Table.%20Is%20there%20a%20way%20to%20sum%20dynamic%20multiple%20cells%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3366254%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20I%20have%20workbook%20that%20with%20a%20pivot%20tablet%20that%20pulls%20in%20data%20from%20a%20sql%20server.%20I%20am%20trying%20to%20sum%20items%20pull%20in%20by%20a%20specific%20lot%20type%2C%20singles%20vs%20towns.%20I%20can't%20use%20countif%2C%20(at%20least%20I%20don't%20think%20I%20can)%2C%20because%20the%20the%20report%20is%20dynamic%20and%20so%20the%20type%20and%20counts%20don't%20always%20appear%20in%20the%20same%20cells%20when%20pulling%20the%20data.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3366254%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3366531%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20with%20adding%20data%20pulled%20in%20with%20Pivot%20Table.%20Is%20there%20a%20way%20to%20sum%20dynamic%20multiple%20cells%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3366531%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1388621%22%20target%3D%22_blank%22%3E%40Keith321%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EPerhaps%20you%20may%20use%20another%20PivotTable%20in%20which%20using%20DAX%20measures%20show%20filtered%20summary.%20If%20you%20are%20on%20Windows%20and%20use%20data%20model.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3366837%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20with%20adding%20data%20pulled%20in%20with%20Pivot%20Table.%20Is%20there%20a%20way%20to%20sum%20dynamic%20multiple%20cells%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3366837%22%20slang%3D%22en-US%22%3EThanks%20for%20the%20suggestion%20Sergei!%20I%20will%20give%20this%20a%20try.%3CBR%20%2F%3E%3CBR%20%2F%3ETake%20care%2C%3CBR%20%2F%3EKeith%3C%2FLINGO-BODY%3E
New Contributor

Hi, I have workbook that with a pivot tablet that pulls in data from a sql server. I am trying to sum items pull in by a specific lot type, singles vs towns. I can't use countif, (at least I don't think I can), because the the report is dynamic and so the type and counts don't always appear in the same cells when pulling the data.

 

2 Replies
best response confirmed by Keith321 (New Contributor)
Solution

@Keith321 

Perhaps you may use another PivotTable in which using DAX measures show filtered summary. If you are on Windows and use data model.

Thanks for the suggestion Sergei! I will give this a try.

Take care,
Keith