+ Reply to Thread
Results 1 to 3 of 3

Pivot Table Filters with Other Pivot Table Filters

  1. #1
    Registered User
    Join Date
    02-14-2023
    Location
    South Africa
    MS-Off Ver
    365
    Posts
    10

    Pivot Table Filters with Other Pivot Table Filters

    Good day

    I am having trouble with the "Filter data independently for each Pivot Table report" function. Despite creating multiple dashboards, I am currently facing difficulties filtering my Pivot Table reports independently, particularly when they are linked to a Slicer. I have removed the Pivot Report connections to the Slicer.

    I am also struggling to create a pivot for the "Date Verified" column, should be Month and Year.

    The formatting of the Data Labels in the Pivot Chart also keeps on auto changing.

    Could you please help me resolve these issues? Is this an Excel software issue? As I cannot find the option to change the filters to be filtered independently?

    Thank you in advance for your assistance in advance.
    Last edited by NadiaVDB; 02-13-2024 at 06:26 AM.

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,570

    Re: Pivot Table Filters with Other Pivot Table Filters

    The pivot tables in this file exhibit some strange behaviors.
    1. Table_query__4 appears to have 1154 ID's however the pivot table named "Total" only reports 639
    2. Table_query__4 only has seven columns, however the pivot table field list for all pivot tables display many more
    3. Table_query__4 has 156 rows with verified dates however the PivotTable6 displays only 129 ignoring for example August of 2023
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

  3. #3
    Forum Expert
    Join Date
    01-05-2013
    Location
    Singapore
    MS-Off Ver
    H&B2016 & H&B2021
    Posts
    3,060

    Re: Pivot Table Filters with Other Pivot Table Filters

    Need to refresh the PivotTables.

+ 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. Pivot Table - Filters
    By stribor40 in forum Excel General
    Replies: 3
    Last Post: 03-22-2023, 01:30 PM
  2. Create regular table from pivot table w/ filters applied
    By MinisoftEggshell in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 03-26-2022, 07:25 AM
  3. [SOLVED] Macro to select multiple pivot table filters, based on values in a table
    By Portuga in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 12-03-2018, 06:42 PM
  4. Macro to update pivot table filters from multiple pivot tables of different data sources
    By groblerdn85 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-24-2017, 05:10 AM
  5. [SOLVED] Pivot Table Filters
    By reedersketer in forum Excel Charting & Pivots
    Replies: 10
    Last Post: 10-12-2017, 08:41 AM
  6. Replies: 1
    Last Post: 07-16-2015, 05:46 AM
  7. [SOLVED] Pivot Table filters
    By kenadams378 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-06-2013, 05:35 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