% of Subtotal in Pivot Table. How to get Subtotal as % of itself?

N

nhulang

New Member
Joined
Jul 13, 2016
Messages
5
Hi There,

I'm showing the % of subtotal in the Pivot Table. But How do I make the Subtotal appear as a % of itself, and not of the grand total?

Essentially, I want the items in the subtotaled section to be a % of subtotal (which I've done), and the subtotal to show as % of itself (ie:100%) (which I can't seem to do)

Any help will be great. Please ask if you need any further clarification!

Thanks!
 
Sort by date Sort by votes
I did not get what you said.
Can you provide an example ? I´ve probably done what you've done so far. What more do you want ?

[TABLE="width: 438"]
<colgroup><col><col><col span="2"><col></colgroup><tbody>[TR]
[TD]Rótulos de Linha[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]3 [/TD]
[TD]Total Geral[/TD]
[/TR]
[TR]
[TD]Ana[/TD]
[TD="align: right"]0,00%[/TD]
[TD="align: right"]19,15%[/TD]
[TD="align: right"]0,00%[/TD]
[TD="align: right"]19,15%[/TD]
[/TR]
[TR]
[TD]And[/TD]
[TD="align: right"]6,38%[/TD]
[TD="align: right"]0,00%[/TD]
[TD="align: right"]0,00%[/TD]
[TD="align: right"]6,38%[/TD]
[/TR]
[TR]
[TD]Clara[/TD]
[TD="align: right"]0,00%[/TD]
[TD="align: right"]12,77%[/TD]
[TD="align: right"]0,00%[/TD]
[TD="align: right"]12,77%[/TD]
[/TR]
[TR]
[TD]Gabi[/TD]
[TD="align: right"]17,02%[/TD]
[TD="align: right"]0,00%[/TD]
[TD="align: right"]0,00%[/TD]
[TD="align: right"]17,02%[/TD]
[/TR]
[TR]
[TD]Leticia[/TD]
[TD="align: right"]21,28%[/TD]
[TD="align: right"]0,00%[/TD]
[TD="align: right"]0,00%[/TD]
[TD="align: right"]21,28%[/TD]
[/TR]
[TR]
[TD]Mag[/TD]
[TD="align: right"]0,00%[/TD]
[TD="align: right"]8,51%[/TD]
[TD="align: right"]0,00%[/TD]
[TD="align: right"]8,51%[/TD]
[/TR]
[TR]
[TD]Pedro[/TD]
[TD="align: right"]0,00%[/TD]
[TD="align: right"]0,00%[/TD]
[TD="align: right"]14,89%[/TD]
[TD="align: right"]14,89%[/TD]
[/TR]
[TR]
[TD]Total Geral[/TD]
[TD="align: right"]44,68%[/TD]
[TD="align: right"]40,43%[/TD]
[TD="align: right"]14,89%[/TD]
[TD="align: right"]100,00%[/TD]
[/TR]
</tbody>[/TABLE]
 
Upvote 0
rafonga said:
I did not get what you said.
Can you provide an example ? I´ve probably done what you've done so far. What more do you want ?

[TABLE="width: 438"]
<tbody>[TR]
[TD]Rótulos de Linha[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]3[/TD]
[TD]Total Geral[/TD]
[/TR]
[TR]
[TD]Ana[/TD]
[TD="align: right"]0,00%[/TD]
[TD="align: right"]19,15%[/TD]
[TD="align: right"]0,00%[/TD]
[TD="align: right"]19,15%[/TD]
[/TR]
[TR]
[TD]And[/TD]
[TD="align: right"]6,38%[/TD]
[TD="align: right"]0,00%[/TD]
[TD="align: right"]0,00%[/TD]
[TD="align: right"]6,38%[/TD]
[/TR]
[TR]
[TD]Clara[/TD]
[TD="align: right"]0,00%[/TD]
[TD="align: right"]12,77%[/TD]
[TD="align: right"]0,00%[/TD]
[TD="align: right"]12,77%[/TD]
[/TR]
[TR]
[TD]Gabi[/TD]
[TD="align: right"]17,02%[/TD]
[TD="align: right"]0,00%[/TD]
[TD="align: right"]0,00%[/TD]
[TD="align: right"]17,02%[/TD]
[/TR]
[TR]
[TD]Leticia[/TD]
[TD="align: right"]21,28%[/TD]
[TD="align: right"]0,00%[/TD]
[TD="align: right"]0,00%[/TD]
[TD="align: right"]21,28%[/TD]
[/TR]
[TR]
[TD]Mag[/TD]
[TD="align: right"]0,00%[/TD]
[TD="align: right"]8,51%[/TD]
[TD="align: right"]0,00%[/TD]
[TD="align: right"]8,51%[/TD]
[/TR]
[TR]
[TD]Pedro[/TD]
[TD="align: right"]0,00%[/TD]
[TD="align: right"]0,00%[/TD]
[TD="align: right"]14,89%[/TD]
[TD="align: right"]14,89%[/TD]
[/TR]
[TR]
[TD]Total Geral[/TD]
[TD="align: right"]44,68%[/TD]
[TD="align: right"]40,43%[/TD]
[TD="align: right"]14,89%[/TD]
[TD="align: right"]100,00%[/TD]
[/TR]
</tbody>[/TABLE]
Click to expand...


Thank you for the response rafonga. Basicly my setup is as follows:

[TABLE="width: 1517"]
<colgroup><col><col><col><col span="9"><col><col span="10"></colgroup><tbody>[TR]
[TD][TABLE="width: 1517"]
<colgroup><col><col><col><col span="9"><col><col span="10"></colgroup><tbody>[TR]
[TD][TABLE="width: 802"]
<colgroup><col><col><col><col span="7"></colgroup><tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]year[/TD]
[TD]Month[/TD]
[TD]Data[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]2015[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]2016[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]11[/TD]
[TD][/TD]
[TD]12[/TD]
[TD][/TD]
[TD]1[/TD]
[TD][/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Team[/TD]
[TD]User Full Name[/TD]
[TD]Category[/TD]
[TD]# of Hours[/TD]
[TD]% of Time[/TD]
[TD]# of Hours[/TD]
[TD]% of Time[/TD]
[TD]# of Hours[/TD]
[TD]% of Time[/TD]
[TD]# of Hours[/TD]
[/TR]
[TR]
[TD]Account[/TD]
[TD]Cust A[/TD]
[TD]Billable[/TD]
[TD="align: right"]71[/TD]
[TD="align: right"]42%[/TD]
[TD="align: right"]59[/TD]
[TD="align: right"]32%[/TD]
[TD="align: right"]72[/TD]
[TD="align: right"]37%[/TD]
[TD="align: right"]83[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Admin/General[/TD]
[TD="align: right"]42[/TD]
[TD="align: right"]25%[/TD]
[TD="align: right"]38[/TD]
[TD="align: right"]21%[/TD]
[TD="align: right"]37[/TD]
[TD="align: right"]19%[/TD]
[TD="align: right"]29[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Education[/TD]
[TD][/TD]
[TD="align: right"]0%[/TD]
[TD][/TD]
[TD="align: right"]0%[/TD]
[TD][/TD]
[TD="align: right"]0%[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]PTO[/TD]
[TD="align: right"]34[/TD]
[TD="align: right"]20%[/TD]
[TD="align: right"]44[/TD]
[TD="align: right"]24%[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]9%[/TD]
[TD="align: right"]40[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Consulting[/TD]
[TD][/TD]
[TD="align: right"]0%[/TD]
[TD][/TD]
[TD="align: right"]0%[/TD]
[TD][/TD]
[TD="align: right"]0%[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Lost[/TD]
[TD="align: right"]23[/TD]
[TD="align: right"]13%[/TD]
[TD="align: right"]45[/TD]
[TD="align: right"]24%[/TD]
[TD="align: right"]68[/TD]
[TD="align: right"]35%[/TD]
[TD="align: right"]27[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Pipeline[/TD]
[TD][/TD]
[TD="align: right"]0%[/TD]
[TD][/TD]
[TD="align: right"]0%[/TD]
[TD][/TD]
[TD="align: right"]0%[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Cust A Total[/TD]
[TD] [/TD]
[TD="align: right"]169[/TD]
[TD="align: right"]17%[/TD]
[TD="align: right"]186[/TD]
[TD="align: right"]18%[/TD]
[TD="align: right"]194[/TD]
[TD="align: right"]18%[/TD]
[TD="align: right"]182[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Cust B[/TD]
[TD]Billable[/TD]
[TD="align: right"]176[/TD]
[TD="align: right"]87%[/TD]
[TD="align: right"]131[/TD]
[TD="align: right"]65%[/TD]
[TD="align: right"]139[/TD]
[TD="align: right"]68%[/TD]
[TD="align: right"]156[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Admin/General[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]7%[/TD]
[TD="align: right"]16[/TD]
[TD="align: right"]8%[/TD]
[TD="align: right"]32[/TD]
[TD="align: right"]16%[/TD]
[TD="align: right"]22[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]PTO[/TD]
[TD][/TD]
[TD="align: right"]0%[/TD]
[TD="align: right"]53[/TD]
[TD="align: right"]26%[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]4%[/TD]
[TD="align: right"]15[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Consulting[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]3%[/TD]
[TD][/TD]
[TD="align: right"]0%[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]4%[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Lost[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0%[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]1%[/TD]
[TD="align: right"]16[/TD]
[TD="align: right"]8%[/TD]
[TD="align: right"]13[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Pipeline[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]3%[/TD]
[TD][/TD]
[TD="align: right"]0%[/TD]
[TD][/TD]
[TD="align: right"]0%[/TD]
[TD="align: right"]6[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Cust B Total[/TD]
[TD] [/TD]
[TD="align: right"]204[/TD]
[TD="align: right"]20%[/TD]
[TD="align: right"]201[/TD]
[TD="align: right"]20%[/TD]
[TD="align: right"]203[/TD]
[TD="align: right"]19%[/TD]
[TD="align: right"]216[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Total # of Hours[/TD]
[TD]Total % of Time[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]



The %s highlighted and underlined, are the subtotals. They appear as % of the grant total instead of a % of themselves. How can I get them also to appear as % of the subtotal for the section ("User full name") , like the %s above them?
 
Upvote 0
You must log in or register to reply here.

Similar threads

S
  • Question Question
Simply current workload. Pivot table?
Replies
0
Views
262
ShadowRider
S
O
  • Question Question
Pivot Total subtotal 2 of 3 columns only
Replies
0
Views
374
Obwan
O
T
  • Question Question
Pivot table: How to calculate new columns based on the pivot table itself?
Replies
4
Views
439
TheWes
T
S
  • Question Question
Repeating a pivot table many times and changing only one column -- are there more efficient approaches?
Replies
0
Views
509
sschaefer
S
JenniferMurphy
  • Question Question
I could use help with a bit of a complex table addressing problem
Replies
1
Views
299
JenniferMurphy
JenniferMurphy

Forum statistics

Threads
1,226,840
Messages
6,193,279
Members
453,788
Latest member
drcharle

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top