+ Reply to Thread
Results 1 to 5 of 5

Pivot table: field both as filter and row type

  1. #1
    Registered User
    Join Date
    03-06-2012
    Location
    singapore
    MS-Off Ver
    Excel 2010
    Posts
    4

    Pivot table: field both as filter and row type

    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?

  2. #2
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Pivot table: field both as filter and row type

    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>
    DILIPandey
    +91 9810929744
    dilipandey@gmail.com

  3. #3
    Registered User
    Join Date
    03-06-2012
    Location
    singapore
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Pivot table: field both as filter and row type

    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...

  4. #4
    Registered User
    Join Date
    03-06-2012
    Location
    singapore
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Pivot table: field both as filter and row type

    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...

  5. #5
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Pivot table: field both as filter and row type

    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>

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1