Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Seeing what fields are showing in a Pivot Report
Hi all,
In 2003, the filter selections were on the graph itself and as such, it was easy to see what filters were in play agaonst what content. As I recently discovered, these filters are present in 2007 in the PivotChart Filter button. But seeing what filters are active isn't immediately obvious unless you click on each filter to see. Is there a way to detect and present these selections? Many thanks, Bony |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Seeing what fields are showing in a Pivot Report
I hope I understand you correctly. Did you click on the "Field List" button?
It's in the Ribbon. "Bony Pony" wrote: Hi all, In 2003, the filter selections were on the graph itself and as such, it was easy to see what filters were in play agaonst what content. As I recently discovered, these filters are present in 2007 in the PivotChart Filter button. But seeing what filters are active isn't immediately obvious unless you click on each filter to see. Is there a way to detect and present these selections? Many thanks, Bony |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Seeing what fields are showing in a Pivot Report
H,
No - I can see the field list fine. It is seeing what filters are active without clicking on the Report Filter section in the PivotChart Filter Pane. Thanks, Bony "pgarcia" wrote: I hope I understand you correctly. Did you click on the "Field List" button? It's in the Ribbon. "Bony Pony" wrote: Hi all, In 2003, the filter selections were on the graph itself and as such, it was easy to see what filters were in play agaonst what content. As I recently discovered, these filters are present in 2007 in the PivotChart Filter button. But seeing what filters are active isn't immediately obvious unless you click on each filter to see. Is there a way to detect and present these selections? Many thanks, Bony |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
fields names do not show in excel 2007 pivot table fields list | New Users to Excel | |||
Excel 2007 Pivot table's Report filter fields value sorting | New Users to Excel | |||
Pivot Tables - Showing Details for some fields, but just summaries for others | Excel Worksheet Functions | |||
Removing The N/A from showing in open fields | Excel Worksheet Functions | |||
Calculated Fields showing error results | Excel Discussion (Misc queries) |