+ Reply to Thread
Results 1 to 2 of 2

Pivot Table Filtered while showing items with no data only for selected period

  1. #1
    Registered User
    Join Date
    08-18-2017
    Location
    Mexico
    MS-Off Ver
    Office 2016
    Posts
    24

    Pivot Table Filtered while showing items with no data only for selected period

    I have a Pivot Table with the following:

    Filters: CQ# (1 through 11)
    Columns: E Values, CQ (CQ3'18, CQ2'18, and so on...)
    Rows: Brand (x, y, z)
    E Values: Units

    In CQ# I have selected Quarters 1 through 9 out of 11 Quarters, therefore I want my Pivot Table to show only these.
    However, if I select "Show Items with No Data" Quarter 10 and 11 will appear in the Pivot with Blank Data.

    What I want to accomplish: I need to know how to create a view where only Quarters 1 through 9 are visible, but the problem is that sometimes some brands will not have data on Quarter 1 and forces me to use the "Show Items with No Data" as I dont want my linked Dashboard formulas to move. However, using this option will keep Quarter 10 and 11 which I don't want in my pivot.

    Is there a way to have filtered data and show items with no data for the selected filters?

    Thanks in advance,
    D2S

  2. #2
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    2013 / 2016
    Posts
    5,833

    Re: Pivot Table Filtered while showing items with no data only for selected period

    I suggest a helper column that evaluates to true for quarters 1 - 9 and false for 10 and 11 and use that as an additional filter on the pivot table.
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

+ 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