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
