4 Replies Latest reply: Feb 1, 2017 8:23 AM by Jose de la Cruz RSS

    Count values of a Pivot table

    Jose de la Cruz

      Hi there,

      I'd like some assistance with a pivot table, I've prepare the Doc attached as reference and I'll try to explain as much as I can. So, I have a column on a pivot table that displays either Passed or Failed depending on the result of another column on the same table, it works fine but I want to change the 'Total' line for that column to display "Failed" if there are 1 or more Failed status on the column. Then I also need to count how many Failed status appear on that column.


      Screenshot below as reference:

      Ex1.PNG