May 10 2022 07:12 PM
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?
May 10 2022 09:32 PM
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.
May 11 2022 07:51 AM
@Riny_van_Eekelen Thanks. That's what I was afraid of. Appreciate the info!
May 10 2022 09:32 PM
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.