Results 1 to 2 of 2

COUNTIFS off of a pivot slicer - bad results

Threaded View

  1. 03-16-2023, 12:38 PM #1
    Shruder
    Shruder is offline
    Forum Contributor
    Join Date
    02-13-2018
    Location
    USA
    MS-Off Ver
    Office 365
    Posts
    183

    COUNTIFS off of a pivot slicer - bad results

    Hi,

    I have a formula stats table to the right of my pivot.

    Below, the pivot slicer has all reps selected. I am looking at Mike specifically. At an unfiltered slicer stage, Mike's results are correct per below

    Mike - Filtered OK.PNG


    However, if you filter to Mike on the Slicer, the results are wrong - image below. I am wondering why that is and if there is another formula to use instead of COUNTIFS?

    Mike Slicer Bad.PNG
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Is it possible to link a table slicer with a pivot slicer?
    By SCarroll in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-01-2023, 12:06 PM
  2. Countifs with Slicer
    By greentea in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-24-2020, 01:45 PM
  3. Disconnect Slicer, Change Pivot Source, Reonnect Slicer
    By ensi in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-27-2020, 04:26 AM
  4. Link a slicer to another slicer without using pivot tables?
    By OryxOmega in forum Office 365
    Replies: 1
    Last Post: 09-11-2019, 11:54 AM
  5. One Pivot table to show different column results with slicer
    By milo1984 in forum Excel General
    Replies: 1
    Last Post: 04-30-2018, 08:09 AM
  6. One Pivot table to show different column results with slicer
    By milo1984 in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 04-30-2018, 06:26 AM
  7. Duplicate slicer selection onto other slicer (master/slave slicer)- super slow performance
    By Shepanator in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-23-2018, 09:43 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1