Need help to insert column in Pivot

[sarat]

Hello Everyone,

I want to populate two more columns in the pivot which displayed only interval total (for SR/LIT and PMS/Registries) although cumulative for column 'cum' is there.

that mean if we consider row number 7, interval total should be displayed as 6
For row number 8, interval total should be displayed as 41


Advance thanks for your support

[sarat]

Hi all,
I just wanted to know whether the requirement is possible or I need to take the help of VBA.


Advance thanks

[Bob Phillips]

Personally, I have no idea what you mean here, so maybe others are having the same problem.

Can you try explaining it some other way?

[sarat]

Thanks XLD for looking into this matter.

For the column ('SR/LIT', 'PMS/Registries'), two sub-columns are there i.e. Serious and Not serious.

For the column Serious and Not serious, two sub columns 'Interval' and 'cum' are there.

In the pivot, sum of values present in column 'cum' (from both Serious and Not serious) are populated in another column 'SR/LIT all'
e.g.
cum (Serious) cum(Not serious) SR/LIT all
for PT 'Agranulocytosis' 3 0 3
'Anaemia' 79 64 143




My requirement : is it possible to combine the data for column 'Interval' (from both Serious and Not serious) an put it in another newly created column like below

Interval (Serious) Interval(Not serious) New column
for PT 'Agranulocytosis' 3 0 3
'Anaemia' 16 25 41



Please check the spreadsheet once again. Pivot should be designed in such a way that two columns should be there