• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Calculations within pivot tables

S

Shaun

Member
Hi All,

I am having a little trouble trying to work out whether it is possible to perform calculations on grouped items within a pivot table and subsequently generate a pivot chart?

I have not been able to work out an "elegant" way to do it, just the clumsily put together example in the attached workbook.

Any help would be awesome.

Cheers

Shaun
 

Attachments

  • Chandoo Example.xlsm
    162.5 KB · Views: 3
Right click on COGS value field. Go to Show Value As tab.
In "Base Item:" locate Income and hit OK.

This will show COGS as % of Income.

However, how your data is organized isn't ideal. I'd recommend reworking your data model.
 

Attachments

  • Chandoo Example.xlsm
    158.7 KB · Views: 5
Hi Chihiro

Thank you, I knew there would be a better way...I just couldn't find it.

Thank you

Shaun
 
You must log in or register to reply here.
Back
Top