Add a new idea Subscribe
Status Shipped
Categories Reports
Created by Guest
Created on Nov 17, 2015

RELATED IDEAS

Pivot Table: Count zero when no associated records

When I create a pivot table and ask that it count the number of records I want to know which rows don't have any associated records.  For example, I created a pivot table with product and release, I then wanted to count the number of features associated with that release.  In this case, I also wanted to see which releases didn't have any features associated with it.  I can also see times when I would only want to see rows that have >0 items.  Maybe a check box on the field selection or the table settings that says "Show rows with no associations" or something to that effect.

 

thanks!

  • Attach files
  • Guest
    Reply
    |     Jan 21, 2016

    The old pivot table appears to have this functionality.  Is that is what is meant by shipped?  Will this functionality be ported over to the new pivot table (which btw I love the new pivot table 1000% better)?

  • Guest
    Reply
    |     Jan 21, 2016

    This says shipped but I don't see it working.  I just created a pivot table with my releases as rows and a count of features in the cells.  I know not all of my releases have features in them, and those releases are not showing only those releases with at least one feature show up.  I need to see all releases.