Results 1 to 4 of 4

Filtering in pivot table

Threaded View

  1. #1
    Registered User
    Join Date
    09-01-2022
    Location
    Denmark
    MS-Off Ver
    365
    Posts
    2

    Filtering in pivot table

    Hi
    I am making a list for sites where our company is going to install a device called WatchDog
    In the screenshot below, i would like to filter an entire "Koncept nr." out, no matter how many rows the "Koncept nr." consists of, if there is a WatchDog in column D for that "Koncept nr.".
    So for example, "Koncept nr." 0326.10 and 0385.10 should disappear, 0394.10 should stay, 0431.10 should disappear, 0438.10 should stay and so on...
    But how do i achieve that in a pivot table?

    Maybe it's only possible with a formula in the original table?
    Attached Images Attached Images
    Last edited by mureren; 06-21-2023 at 03:06 AM.

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: 09-19-2021, 08:29 PM
  2. Replies: 5
    Last Post: 07-01-2019, 08:01 AM
  3. [SOLVED] filtering a pivot chart / pivot table on x-axis values
    By Trebor777 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 12-20-2016, 01:28 PM
  4. Replies: 0
    Last Post: 07-29-2015, 09:41 PM
  5. [SOLVED] Filtering Data Pivot Table is Based On - Impact on Pivot Table
    By bbg22 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 07-17-2013, 06:34 AM
  6. Filtering a Pivot Table according to 'Future' Pivot Items
    By Eraserhead in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-27-2012, 03:25 PM
  7. VBA Pivot Table Filtering
    By datawrecker in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-03-2010, 09:44 AM

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