• 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.

Computed columns in Pivot

nvgroups

New Member
I am using Excel 2013.

My pivot has the following columns

Sales in Continent and country
Cosumables Perishables
======================== =============
Country Name Item 1 Item 2 Total Item 1 Item 2 Total
Asia
================
Country 1
Country 2
Country NN

Africa
=========
Country 1
Country 2
Country NN

I don't have a total column in my data.
I need new computed columns showing the % of Item 1 totals, Item 2 totals for consumables, perishables and grand totals.

Pl help me!
 
Last edited:
Upload sample pivot table along with raw data (enough to demonstrate your data set).

Mirror your workbook set up (Pivot based on Table/OLAP etc).
 
Back
Top