View Full Version : Need help to insert column in Pivot
sarat
02-11-2013, 03:04 AM
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
02-13-2013, 11:53 AM
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
02-14-2013, 04:00 AM
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
02-14-2013, 09:22 AM
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
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.