Pivot Table Help- Showing both Percentage and Total as Sum

[jfish1288]

I feel like there is an easy built in solution, but I am struggling with this.

I would like to show the values as a percentage of the row total, and the grad total for each row as the actual summed value (not 100%).

Below is a screen shot of what I get with no calculation, and with "Show Values as" set to "% of Row Total"

The combination in green is what I am trying understand how to do with the pivot table.

[/URL]
free image web hosting
[/IMG]

 

[DanteAmor]

It may be so

<b>SHEET</b><br /><br /><table border="1" cellspacing="0" style="font-family:Calibri,Arial; font-size:11pt; background-color:#ffffff; "> <colgroup><col style="font-weight:bold; width:30px; " /><col style="width:80px;" /><col style="width:80px;" /><col style="width:80px;" /><col style="width:80px;" /><col style="width:88px;" /><col style="width:111px;" /><col style="width:67px;" /><col style="width:75px;" /><col style="width:52px;" /><col style="width:84px;" /><col style="width:84px;" /></colgroup><tr style="background-color:#cacaca; text-align:center; font-weight:bold; font-size:8pt; "><td > </td><td >A</td><td >B</td><td >C</td><td >D</td><td >E</td><td >F</td><td >G</td><td >H</td><td >I</td><td >J</td><td >K</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >1</td><td >Labels</td><td >LET</td><td >VALUE</td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >2</td><td >A</td><td >X</td><td style="text-align:right; ">5</td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >3</td><td >B</td><td >X</td><td style="text-align:right; ">6</td><td > </td><td > </td><td >LET</td><td >Valores</td><td > </td><td > </td><td > </td><td > </td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >4</td><td >C</td><td >X</td><td style="text-align:right; ">18</td><td > </td><td > </td><td >X</td><td > </td><td >Y</td><td > </td><td >Total Suma de VALUE</td><td >Total Suma de VALUE2</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >5</td><td >A</td><td >Y</td><td style="text-align:right; ">5</td><td > </td><td >Labels</td><td >Suma de VALUE</td><td >Suma de VALUE2</td><td >Suma de VALUE</td><td >Suma de VALUE2</td><td > </td><td > </td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >6</td><td >B</td><td >Y</td><td style="text-align:right; ">14</td><td > </td><td >A</td><td style="text-align:right; ">50.00%</td><td style="text-align:right; ">5</td><td style="text-align:right; ">50.00%</td><td style="text-align:right; ">5</td><td style="text-align:right; ">100.00%</td><td style="text-align:right; ">10</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >7</td><td >C</td><td >Y</td><td style="text-align:right; ">2</td><td > </td><td >B</td><td style="text-align:right; ">30.00%</td><td style="text-align:right; ">6</td><td style="text-align:right; ">70.00%</td><td style="text-align:right; ">14</td><td style="text-align:right; ">100.00%</td><td style="text-align:right; ">20</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >8</td><td > </td><td > </td><td > </td><td > </td><td >C</td><td style="text-align:right; ">90.00%</td><td style="text-align:right; ">18</td><td style="text-align:right; ">10.00%</td><td style="text-align:right; ">2</td><td style="text-align:right; ">100.00%</td><td style="text-align:right; ">20</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >9</td><td > </td><td > </td><td > </td><td > </td><td >Total general</td><td style="text-align:right; ">58.00%</td><td style="text-align:right; ">29</td><td style="text-align:right; ">42.00%</td><td style="text-align:right; ">21</td><td style="text-align:right; ">100.00%</td><td style="text-align:right; ">50</td></tr></table> <br /><br />

 

[jfish1288]

Yes, I know I can do this method. But I was looking for a solution that did not require showing each attribute as both a sum and a percentage. I am looking for the more simple view highlighted in green above.

 

[DanteAmor]

I understand, but the table has its limitations, like many things in excel, you apply something and adjust something. You can apply the method and hide the columns that you do not need.

Excel Workbook
	A	B	C	D	E	F	H	K
1	Labels	LET	VALUE			X	Y
2	A	X	5		Fila	% VALUE	% VALUE	TOTAL VALUE 2
3	B	X	6		A	50.00%	50.00%	10
4	C	X	18		B	30.00%	70.00%	20
5	A	Y	5		C	90.00%	10.00%	20
6	B	Y	14		Total general	58.00%	42.00%	50
7	C	Y	2
Hoja1