# Pivot Table Sub-Total and Total Settings for Percentages

1. ## Pivot Table Sub-Total and Total Settings for Percentages

Hello,

On the attached worksheet I have everything set up how I would like in a pivot table, however I am wondering where or what the setting should be for subtotals of the Profit Margin category?

The sheet currently auto-sum's the column, which i'm sure is default. How do I change it so that Cells I19, I34, and I36 are not added up, but are actually the quotient of the 2 cells before?

This is exactly what i'm looking to accomplish:

I9=(H9/G9)
I34=(H34/G34)
I36=(H36/G36)

Thanks,

2. ## Re: Pivot Table Sub-Total and Total Settings for Percentages

I assume you want subtotals for each month. If that is the case - Select a cell in the month column of your pivot table and right click.. It will giv eyou the option to subtotal

Does this help

3. ## Re: Pivot Table Sub-Total and Total Settings for Percentages

No. What I'm looking for is the Margin percentage for INTER Total, DIRECT Total, and GRAND Total (Cells I19, I34, and I36). Currently it only gives the SUM of the column.

This would be achieved by dividing the previous 2 columns, so:

I19 would equal H19/G19
I34 would equal H34/G34
I36 would equal H36/G36

Is there a setting for this?

4. ## Re: Pivot Table Sub-Total and Total Settings for Percentages

My misunderstanding

Click in the pivot table to get the pivot menu
Insert / Calculated field

Enter formula Margin/Invoice
Set Format to %
Remove existing margin from pivot table

This should work

Cheers

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1