Pivot table: field both as filter and row type

**boooinky** · 03-27-2012, 05:38 AM

I want to include a pivot field both as a filter as well as a row type, but the moment I add it to the filter, it disappears from the row type.
How do I solve this problem?

**dilipandey** · 03-27-2012, 06:33 AM

Hi boooinky,

In pivot, a filed can be in row filed or in column field only... can not be present on both at the same time.
Instead, you can have it additionally on the page field.. for fiter purpose.

Regards,
DILIPandey

<click on below 'star' if this helps>

**boooinky** · 03-27-2012, 11:04 PM

In this case, I want the field to appear both in the Report Filter area as well as the Row Label area i.e I want to filter according to the field as well as display that field in the main table...

**dilipandey** · 03-28-2012, 10:35 AM

yes.. you can do that..!!

If you still face any issue, post the sample file. thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

**StupidHandle** · 09-26-2022, 11:03 AM

I was pleased to see that this is doable, but I need specific instructions for how to do it in Excel. Please could someone post a "how-to"? Thanks very much in advance.

**6StringJazzer** · 09-26-2022, 02:46 PM

Originally Posted by StupidHandle

I was pleased to see that this is doable, but I need specific instructions for how to do it in Excel. Please could someone post a "how-to"? Thanks very much in advance.

Administrative Note:

Welcome to the forum.

This thread is over 10 years old and the person answering it has not posted for over a year and half. It is very unlikely you will get an answer here.

We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

Please see Forum Rule #4 about hijacking and start a new thread for your query.

If you are not familiar with how to start a new thread see the FAQ: How to start a new thread

In your new thread give a complete explanation of what you want to do and attach a sample file if that helps to explain your question.