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 calculated field Count(field) / sum(field) 0
pivot table calculated field 1
Delete Pivot Table Calculated Field 2
Calculated Field in Pivot Table minimum value 0
Sub Totals as a calculated field in a pivot table 2
Calculated Field in Pivot Table 1
Pivot table, IF function, calculated item versus calculated field 1
Calculated Field pivot Table Question 2

Top