adding a column to existing pivot table.

[marksmunich]

I have a piviot table, i would like to create a new piviot table with an extra column, the data in a new table will be same as old with a new coulmn  which will be a calcualted value. for example consider salary for working hours. one column already has data about the working hours, how can i calculate the pay per hour in the next column to it.

[khadeer]

Hi,

You have to add new dimension or calculated dimension to new pivot table.You have to add depend on your requirement.

Regards,

Khadeer

[marksmunich]

yeah i found the solution for it.

[#4]

Please can you share?

Thanks

[#5]

Thanks, But how do you add another column in a pivot table?

[narender123]

If you want to add column then simple in dimention add column .if you want to add expression as mohit expression then add expression in expression.

Thanks

[#7]

Thank you both very much. But in my pivot table i have a main heading which has sub-headings. I want to add a column to the end of my pivot table which contains, for each row, the sum of two of the columns divided by another column. Hown could I do this?

Thanks

[narender123]

Hi,

Give me some example that what you want.

Thanks

[#9]

Hi,

Thamks for your help.

At the moment I have the following pivot table:

Transport           Type
Date	Car	Van	Cycle	Total
Jan-13	A1	B1	C1	Sum(A1:C1)
Feb-13	A2	B2	C2	Sum(A2:C2)
Mar-13	A3	B3	C3	Sum(A3:C3)
Apr-13	A4	B4	C4	Sum(A4:C4)
May-13	A5	B5	C5	Sum(A5:C5)
Jun-13	A6	B6	C6	Sum(A6:C6)
Jul-13	A7	B7	C7	Sum(A7:C7)

But I want to get:

Transport Type
Date	Car	Van	Cycle	Total	Car Proportion	Car and Van Proportion
Jan-13	A1	B1	C1	Sum(A1:C1)	A1/Sum(A1:C1)	(A1+B1)/Sum(A1:C1)
Feb-13	A2	B2	C2	Sum(A2:C2)	A2/Sum(A2:C2)	(A2+B2)/Sum(A2:C2)
Mar-13	A3	B3	C3	Sum(A3:C3)	A3/Sum(A3:C3)	(A3+B3)/Sum(A3:C3)
Apr-13	A4	B4	C4	Sum(A4:C4)	A4/Sum(A4:C4)	(A4+B4)/Sum(A4:C4)
May-13	A5	B5	C5	Sum(A5:C5)	A5/Sum(A5:C5)	(A5+B5)/Sum(A5:C5)
Jun-13	A6	B6	C6	Sum(A6:C6)	A6/Sum(A6:C6)	(A6+B6)/Sum(A6:C6)
Jul-13	A7	B7	C7	Sum(A7:C7)	A7/Sum(A7:C7)	(A7+B7)/Sum(A7:C7)

How could I do this?

Many Thanks.

[#10]

Did u find the solution ? I do have the similar problem.Can you please help me out?