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.
MinString behaves like Min() function but it works on a text field. In your case there were two options: Passed and Failed and since F is smaller than P, MinString looked at all your rows and picked the lowest text to display for the total row.