Forum Discussion

eyadnt83's avatar
eyadnt83
Copper Contributor
Apr 10, 2022

Calculated fields in pivot tables - field settings is grayed out.

Hello Experts,   I am working on an Excel worksheet of movies revenues, and I am using a pivot table to summarize and perform calculations.   I want to calculate the average profit for each movie...
BI & Data Analysis
excel
Excel on Mac
Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Apr 10, 2022

eyadnt83 Any chance you can share the file? OneDrive, Dropbox or similar. 

  • eyadnt83's avatar
    eyadnt83
    Copper Contributor
    Apr 10, 2022
    Hello Riny, Thanks for the quick response.

    please check this link and let me know if you couldn't access it:

    https://onedrive.live.com/edit.aspx?resid=B1E92A83BA5B2AB0!116&ithint=file%2cxlsx
    Regards,
      • eyadnt83's avatar
        eyadnt83
        Copper Contributor
        Apr 10, 2022
        Soory for that.

        I uploaded to wetransfer, I think it will work now:

        https://we.tl/t-JLzpxg3K2V

Resources