Pivout Table group specific period

[Excel Fox]

Howardc,

Are you asking how to create the existing pivot table in the attached workbook? from what I see, that's different from what you've mentioned

set up a Pivot table to show the total Cost & NBV (New Book Value) per asset type for the 2012 Financial Year (Oct 2011 - Sept 2012)

[Howardc]

Howardc,

Are you asking how to create the existing pivot table in the attached workbook? from what I see, that's different from what you've mentioned

Hi Excelfox

I want extract into a Pivot table data pertaining to a financial year. I would have to set up a formula in the sheet containing the raw data before creating the Pivot table