I have a pivot table
how to use " Or" in two columns when we make filter
I want to view all rows which
Column1 = "cat" [COLOR="red"]Or[/COLOR] column2 = "cat"
Not
Column1 = "cat" [COLOR="red"]AND[/COLOR] column2 = "cat"
By code or any way
Thanks!
Apply filtering to multiple columns in a Pivot Table
-
-
-
Re: Apply filtering to multiple columns in a Pivot Table
Starting outside of the Pivot Table in the column immediately to the right of the table and on the same row as the Row Labels, click and drag right (into) the Table then apply filters as you would a normal range.
Example if the column-F, row 3 is cell to immediate right of the last column of Pivot Table, select this select, hold down the mouse button and drag into the PT to highlight all cells on same row as the Row Labels. The apply auto filter.
Please note the change to your title.
-
Re: Apply filtering to multiple columns in a Pivot Table
forum.ozgrid.com/index.php?attachment/35778/thanks AAE
l=please see this file
[Blocked Image: http://posterous.com/getfile/files.posterous.com/mennah/Q3HJX6IgKf5X2hGqe3vBGnm7jT4GvEulNv5sFfaMzkrDo1755NcC9izcTo1p/Capture22121.jpg]
-
Re: Apply filtering to multiple columns in a Pivot Table
any help?
-
Re: Apply filtering to multiple columns in a Pivot Table
Excel 2010 (only)
PivotTable
OR rows
With macro
http://c3017412.cdn.cloudfiles…cecloud.com/01_15_11.xlsm
http://www.mediafire.com/file/cpv1jb2mangba9i/01_15_11.pdf -
-
Re: Apply filtering to multiple columns in a Pivot Table
Thank you
in 2007
what is Alternative -
Re: Apply filtering to multiple columns in a Pivot Table
OR filter
Alternative: Advanced Filter
http://c3017412.cdn.cloudfiles…cecloud.com/01_15_11.xlsm
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!