#1
|
|||
|
|||
Pivot Table's fields
Hi
I'm quite an amateur in Excel, using pivot tables first time, and I've got such a problem: I have a table with 'date' column, and I want to report ONLY records of this month for example. I click 'date' field in pivot menu -> date filters -> this month. And then I have to activate this field(it shows in each record and group) to have filtered data but that's what I don't want to do. When I create report table of current month, I don't want to see that each record is in fact in current month because I know it, as I filter it with data filter. When I use 'report filter' it's wrong because it cannot use filter data, but only simple equality filter (2009-10-12, 2009-11-10, not all in year 2009 for example). Thanks for any answers. |
#2
|
|||
|
|||
Did you solve your problem?
|
#3
|
|||
|
|||
No, I didn't.
|
#4
|
|||
|
|||
Could you send to me the file and an example of the info how you want to see
|
#6
|
|||
|
|||
|
#7
|
|||
|
|||
Thanks Fernando, that was my point.
Problem solved. |
#8
|
|||
|
|||
ok nice stuff
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Question abou Pivot Tables | B2W | Excel | 1 | 02-05-2010 01:05 PM |
Excel pivot table into an MS Word Doc "office 2007" | wmarsh3561 | Excel | 1 | 01-09-2010 08:03 PM |
Linking Excel Pivot Tables in a Word Document | wmarsh3561 | Word Tables | 0 | 11-17-2009 06:29 AM |
editable fields only | kingevil | Word | 0 | 05-04-2008 01:07 PM |
MS access fields | quince | Office | 1 | 11-14-2005 07:28 PM |