Pivot Table Fields

[gehusi]

Hi, I'd like to display two data points in a single pivot table - the count of the base data, as well as the percentage of the row. I know how to do one or the other, but is it possible to build a table which displays both next to one another?

 

[GlennUK]

Yes, I'd say so. Can you give an example of your data, and say what your PivotTable layout currently is?

 

[gehusi]

I have a list of account groupings as row fields. The column field has several account types. The data field is a count of the number of accounts within a group that falls into each type. I'd like to display not only the count (the actual number of accounts within a group in each type), but the percentage that count represents of the total within that row. Something like this:

Count Type 1 Type 2 Type 3 Total
Group 1 10 20% 15 30% 25 50% 50 100%
Group 2 33 23% 21 15% 88 62% 142 100%


Let me know if I haven't explained that well.

 

[GlennUK]

Just add the Type to the data again and change the field setting "Show Values As" to be "% of row". Like this:

Excel Workbook
	A	B	C	D	E	F	G	H	I	J	K	L
1	Group	Type			Type	Data
2	Group 1	Type 3			Type 1		Type 2		Type 3		Total Count of Type	Total Count of Type2
3	Group 2	Type 1		Group	Count of Type	Count of Type2	Count of Type	Count of Type2	Count of Type	Count of Type2
4	Group 1	Type 1		Group 1	54	38.30%	42	29.79%	45	31.91%	141	100.00%
5	Group 2	Type 2		Group 2	41	33.33%	42	34.15%	40	32.52%	123	100.00%
6	Group 1	Type 1		Grand Total	95	35.98%	84	31.82%	85	32.20%	264	100.00%
7	Group 2	Type 1
8	Group 1	Type 1
9	Group 2	Type 1
10	Group 1	Type 3
Sheet12

 

[gehusi]

That did it. Thank you for the tip!