SOLVED

Add a Measure to Pivot Table but Table is not showing

%3CLINGO-SUB%20id%3D%22lingo-sub-3354833%22%20slang%3D%22en-US%22%3EAdd%20a%20Measure%20to%20Pivot%20Table%20but%20Table%20is%20not%20showing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3354833%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20trying%20to%20add%20a%20measure%20to%20my%20pivot%20table.%26nbsp%3B%20But%20I'm%20unable%20to%20do%20so%20because%20table%20that%20I%20pulled%20the%20data%20from%20is%20not%20showing%20under%20PivotTable%20Fields%20list.%26nbsp%3B%20I%20don't%20have%20PowerPivot%20to%20set%20this%20up.%26nbsp%3B%20Any%20suggestions%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3354833%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3355067%22%20slang%3D%22en-US%22%3ERe%3A%20Add%20a%20Measure%20to%20Pivot%20Table%20but%20Table%20is%20not%20showing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3355067%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1386567%22%20target%3D%22_blank%22%3E%40rmclemons78%3C%2FA%3E%26nbsp%3BMeasures%20are%20a%20part%20of%20Power%20Pivot%20(PP).%20So%20if%20you%20don't%20have%20PP%2C%20you%20can't%20use%20measures.%20And%20if%20the%20workbook%20contains%20tables%20created%20in%20PP%2C%20you%20can%20see%20the%20output%2C%20but%20you%20can%20do%20nothing%20with%20it%20%26nbsp%3Bif%20you%20don't%20have%20PP%20yourself.%20For%20instance%2C%20open%20a%20workbook%20with%20PP%20pivot%20tables%20on%20a%20Mac%2C%20you%20can%20see%20the%20table%20but%20you%20can%20not%20filter%2Fsort%2Fexpand%20or%20do%20anything%20with%20it%20and%20the%20Pivot%20Table%20Analyse%20(and%20Design)%20tabs%20will%20not%20become%20visible.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3358119%22%20slang%3D%22en-US%22%3ERe%3A%20Add%20a%20Measure%20to%20Pivot%20Table%20but%20Table%20is%20not%20showing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3358119%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3B%20Thanks.%26nbsp%3B%20That's%20what%20I%20was%20afraid%20of.%26nbsp%3B%20Appreciate%20the%20info!%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I'm trying to add a measure to my pivot table.  But I'm unable to do so because table that I pulled the data from is not showing under PivotTable Fields list.  I don't have PowerPivot to set this up.  Any suggestions?

2 Replies
best response confirmed by Hans Vogelaar (MVP)
Solution

@rmclemons78 Measures are a part of Power Pivot (PP). So if you don't have PP, you can't use measures. And if the workbook contains tables created in PP, you can see the output, but you can do nothing with it  if you don't have PP yourself. For instance, open a workbook with PP pivot tables on a Mac, you can see the table but you can not filter/sort/expand or do anything with it and the Pivot Table Analyse (and Design) tabs will not become visible.

 

@Riny_van_Eekelen  Thanks.  That's what I was afraid of.  Appreciate the info!