Add the same field twice to a pivot table but filter one of them?

  • Thread starter Thread starter eggman2001
  • Start date Start date
E

eggman2001

In my datasheet, I have a "cost" column and a "date" column so each
cost has an associated date. In my pivot table, I've added the "cost"
as a field, which shows the total and this is fine. However, I'd like
to add the "cost" as a field again and this time selecting which dates
to include in the cost number so that I have two cost fields side by
side. Is something like this possible?
 
Hi

That is not possible in the same PT.
You will need to set up a second PT based upon the same data set as the
first but do NOT use the same Pivot Cache to save memory.
You can place the 2 PT's side by side on a sheet, and you could apply date
filters to one, without affecting the other.
 
In my datasheet, I have a "cost" column and a "date" column so each
cost has an associated date. In my pivot table, I've added the "cost"
as a field, which shows the total and this is fine. However, I'd like
to add the "cost" as a field again and this time selecting which dates
to include in the cost number so that I have two cost fields side by
side. Is something like this possible?
Click to expand...

Hi

I'm not sure I understand what you are trying to achieve but if you
want to duplicate
a data field the only way i can think of is to use a calculated field
formula where the formula is simply "=Cost"

Regards

David
 
Back
Top