pivot table question - want to get a range of values as a field

E

eggman2001

My data table has a 'costs' and 'date' column. I'm interested in
getting data from the last 7 days and having it in the field list so
that I can use it as part of a formula. Does anyone know how I can do
this?
 

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

Dealing with a Pivot Table (when I don't want to) 0
Doughnut Chart linked with the slicer in the pivot table 0
Dealing with the error: unable to filter on excel hc home school 0
SUM & OFFSET & PIVOT TABLE?? 0
Formula within Pivot Table Calculated Field - Days in time period 0
Autonumber field in Excel that behaves the same as Access 0
Excel 2013 Pivot Data Range formula reference problem 0
Sub Totals as a calculated field in a pivot table 2

Top