B
BANoble
I am a relatively new user of pivot tables and have run across a problem
I need some help with. I have created a pivot table with the row labels
as follows:
SpecialistName
Physician
HospitalName
The Column is:
YearQTR which has two quarters in it. So the pivot table makes two
columns – 2003Q1 and 2003Q2
I am then counting a field called TotalDischarges so I will get the
total discharges for each physician and hospital they are using.
I created a calculated item calling it differences 2003Q1 – 2003Q2 to
obtain the increase or decrease from 1st and 2nd quarter.
Here comes my problem – the calculation works correctly, but now under
physician the pivot table lists all hospitals from the data for every
physician instead of only the hospitals they have discharges from.
Needless to say the spreadsheet is not large enough to hold all of this
information and I am no longer looking at a summary report. How do I
calculate the differences between quarters and keep a summary pivot
table?
Thank you for any help. I need to figure this out.
I have attached what I need the report to look like. You will see where
I had to do a workaround to get it done.
I need some help with. I have created a pivot table with the row labels
as follows:
SpecialistName
Physician
HospitalName
The Column is:
YearQTR which has two quarters in it. So the pivot table makes two
columns – 2003Q1 and 2003Q2
I am then counting a field called TotalDischarges so I will get the
total discharges for each physician and hospital they are using.
I created a calculated item calling it differences 2003Q1 – 2003Q2 to
obtain the increase or decrease from 1st and 2nd quarter.
Here comes my problem – the calculation works correctly, but now under
physician the pivot table lists all hospitals from the data for every
physician instead of only the hospitals they have discharges from.
Needless to say the spreadsheet is not large enough to hold all of this
information and I am no longer looking at a summary report. How do I
calculate the differences between quarters and keep a summary pivot
table?
Thank you for any help. I need to figure this out.
I have attached what I need the report to look like. You will see where
I had to do a workaround to get it done.