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

[nhulang]

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!

 

[rafonga]

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 ?

Rótulos de Linha	1	2	3	Total Geral
Ana	0,00%	19,15%	0,00%	19,15%
And	6,38%	0,00%	0,00%	6,38%
Clara	0,00%	12,77%	0,00%	12,77%
Gabi	17,02%	0,00%	0,00%	17,02%
Leticia	21,28%	0,00%	0,00%	21,28%
Mag	0,00%	8,51%	0,00%	8,51%
Pedro	0,00%	0,00%	14,89%	14,89%
Total Geral	44,68%	40,43%	14,89%	100,00%

<colgroup><col><col><col span="2"><col></colgroup><tbody>
</tbody>

 

[nhulang]

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 ?

Rótulos de Linha	1	2	3	Total Geral
Ana	0,00%	19,15%	0,00%	19,15%
And	6,38%	0,00%	0,00%	6,38%
Clara	0,00%	12,77%	0,00%	12,77%
Gabi	17,02%	0,00%	0,00%	17,02%
Leticia	21,28%	0,00%	0,00%	21,28%
Mag	0,00%	8,51%	0,00%	8,51%
Pedro	0,00%	0,00%	14,89%	14,89%
Total Geral	44,68%	40,43%	14,89%	100,00%

<tbody>
</tbody>

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

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

<colgroup><col><col><col><col span="9"><col><col span="10"></colgroup><tbody>
</tbody>

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?

 

[rafonga]

Did you forget to paste the last percentage column ?