//sk - Calculated addnl. field in Pivot Table and Chart.

Hi. i have a field as Category in a table with the values defined as "SOH" & "SI". The data - sample pivot table appears like this -

Category	4-Dec-17	5-Dec-17	6-Dec-17	7-Dec-17
SOH	504	281	303	140
SI	323	228	163	57

i need to mention an addnl. row calculated as "SI / SOH" in percentage terms. SI to be divided by SOH.

As per my understanding - adding the calculated field - takes the reference to the column heading / field. whereas i want calculation to be done on the two separate values namely SOH and SI - under a single column heading - Category.

 

 

also, if the same data is plotted in the Pivot Chart as Bard Graph. How can i include the calculated % on the secondary axis.?

 

Pls. guide.

 

Br,

Sansk