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

[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?

 

[Roger Govier]

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.

 

[TheHeatons]

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

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