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

Giganews Newsgroups
Subject: Add the same field twice to a pivot table but filter one of them?
Posted by:  eggman2001 (soda…@gmail.com)
Date: Mon, 9 Mar 2009

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?

Replies