ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Seeing what fields are showing in a Pivot Report (https://www.excelbanter.com/excel-discussion-misc-queries/213320-seeing-what-fields-showing-pivot-report.html)

Bony Pony[_2_]

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

pgarcia

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


Bony Pony[_2_]

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



All times are GMT +1. The time now is 06:01 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com