ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Pivot table filters (https://www.excelbanter.com/excel-discussion-misc-queries/139284-pivot-table-filters.html)

MLK

Pivot table filters
 
I have a pivot table that currently displays hundreds of projects.

However, I need to have a way to ensure that users are only able to display
no more than one project at a time. Is there a way to do this.

The users can change the projects at any time, but I still only want to show
no more than one line at a time.

Thanks, Mary-Lou



MLK

Pivot table filters
 
It's ok, I just figured out how.


"MLK" wrote:

I have a pivot table that currently displays hundreds of projects.

However, I need to have a way to ensure that users are only able to display
no more than one project at a time. Is there a way to do this.

The users can change the projects at any time, but I still only want to show
no more than one line at a time.

Thanks, Mary-Lou




All times are GMT +1. The time now is 09:32 AM.

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