Calculated Field in Pivot Table

P

pinkfloydfan

Dear Group

I have some data in a spreadsheet of the following format:

Item StartDate EndDate Price
AAA 1Jun2000 1Jun2002 1000
BBB 1Aug2001 1Aug2003 1500
CCC 1Sep2002 1Sep2004 2000

I want to put this into a pivot table where the column labels are all
months (preferably grouped into years) and the Value fields show the
Total Price of all Items whose StartDate is less than or equal to that
month and whose EndDate is less than that month.

So, for example, it may look something like:

Jun2000 Aug2001 Jun2002 Sep2002 Aug2003 Sep2004
1000 2500 1500 3500
2000 0

Does anybody know if this is possible to do in a calculated field and
if so what the correct formula is?

Many thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Table Comparison 0
Formula within Pivot Table Calculated Field - Days in time period 0
how to solve the following in excel 1
pivot table calculated field 1
Slicers and Calculated Items in Pivot Table 2
Sub Totals as a calculated field in a pivot table 2
Copy Pivot calculated field to another pivot 0
Pivot table, IF function, calculated item versus calculated field 1

Top