+ Reply to Thread
Results 1 to 2 of 2

How can I row filter based on a string value in a pivot table excel?

  1. #1
    Registered User
    Join Date
    11-24-2021
    Location
    DC
    MS-Off Ver
    Office 365
    Posts
    2

    How can I row filter based on a string value in a pivot table excel?

    I have a table See image for people - years for rows, and hours - target hours - compliantcheck for values. Compliant check is a measure that returns either "Compliant" or "Non-Compliant" based on a calculation if hours exceed target.

    I am trying to filter the entire table to only display the rows with Non-Compliant value. I tried value filters on name and year (Separately) but you cant do that with a string value. I Added a 0/1 column to fix that - but it returned incorrect data. I tried with a vba filter and it also ran into errors.

    Please Login or Register  to view this content.
    Solution can be any method. Whether dax measure, manual filter, or vba.
    Last edited by nate4314; 11-30-2021 at 07:15 PM.

  2. #2
    Forum Contributor
    Join Date
    10-14-2020
    Location
    Shanghai
    MS-Off Ver
    O365
    Posts
    156

    Re: How can I row filter based on a string value in a pivot table excel?

    Hi

    sorry, upload a sample file and we can help. Based on your explanation its not clear and take to long time to rebuild something

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 07-16-2015, 05:46 AM
  2. Replies: 6
    Last Post: 07-31-2014, 12:56 PM
  3. Replies: 2
    Last Post: 06-02-2014, 10:50 AM
  4. Replies: 1
    Last Post: 02-07-2014, 03:12 AM
  5. Replies: 1
    Last Post: 02-07-2014, 03:04 AM
  6. Change Pivot table Filter Based on Cell Value *Multiple Filter items* Possible?
    By Flydd in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-27-2012, 06:57 AM
  7. [SOLVED] Filter based on Pivot table
    By michaelp in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-06-2005, 08:55 PM

Tags for this Thread

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