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