How to add extra calculated rows?

[#1]

hi, i have a 2-D (State and Group) pivot table showing count, as below:

State     Group     g1     g2     g3     Total

Total          100     200     300     600

s1          90     190     285     565

s2          10     10     15     35

now i want to add one row at bottom to calculate percentage of State s2 out of Total per Group, like below:

State     Group     g1     g2     g3     Total

Total          100     200     300     600

s1          90     190     285     565

s2          10     10     15     35

s2 %          10%     5%     5%     

is this possible and can anyone tell how to do it?

or any other alternatives?

thanks,

little

[#2]

thank you all,

but my data is flat, as below:

Identifier	Group	State
2	g1	s1
3	g1	s2
4	g2	s1
5	g2	s2
6	g1	s1
7	g1	s2
8	g2	s1
9	g2	s2
10	g1	s1
11	g1	s1

then in my veiw, i create below 2-D cross table:

State	Group	g1	g2	Total
s1		4	2	6
s2		2	2	4
Total		6	4	10

and what i want to add is to this 2-D cross table:

State	Group	g1	g2	Total
s1		4	2	6
s2		2	2	4
Total		6	4	10
s2 %		33%	50%	40%

[jagan]

Hi,

Did you checked the attachment?

Regards,

Jagan.

[#4]

yes Jagan. seems like your example is only with 1 dimension, but mine is 2-D cross table.

[jagan]

Hi,

Can you attach sample file that you are working?  It helps in solving the problem.

Regards,

Jagan.

[#6]

PFA.

Thanks,

Sean

[jagan]

Hi,

If you 2 states then above attached file is the best option, otherwise you need to create another chart to display percentage alone.

Hope this helps you.

Regards,

Jagan.

[#8]

hi , littleyoung how did u get your respond about s2%?