Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Pivot Table and filtering

Status
Not open for further replies.
MO22

MO22

Technical User
Apr 20, 2001
43
CA
Can I use a filter in a pivot table without using the "filtered" column as a field in the layout?

I want to use Column A and Column B only in my table, but only for those entries that have a specific value in Column C. Am I making any sense?
 
Status
Not open for further replies.

Similar threads

Cpreston
  • Locked
  • Question
Pivot Table Issue
Replies
6
Views
358
Andrzejek
Andrzejek
remeng
  • Locked
  • Question
Excel Pivot Table - Combine Values into a single row
Replies
16
Views
2K
remeng
remeng
E
  • Locked
  • Question
Extract lines from table into new table
Replies
2
Views
634
SkipVought
S
GPnew
  • Locked
  • Question
Power Pivot Filter out Rows where data is not in all columns
Replies
14
Views
919
combo
combo
remeng
  • Question
Power Query Split by Table Group by Rows into a new set of group by tables
Replies
2
Views
218
remeng
remeng

Part and Inventory Search

Sponsor

Back
Top