Distinct Count in Pivot Tables

[shubhadeepsarkar]

Short, to the point and useful 👍. thanks

[jasoncoyne]

I've spent the last hour trying to find this out... How your video does not have more views I do not know! Thank you!

[OpeItsJoey]

Works great - thanks for keeping the video short

[divyasnarayan]

How to use a pivot table to find the count of failed and passed test cases in a each of the column with test report having 4 columns filled with only the values "pass" or "fail

[marimargonzaga]

I think it only works for certain Excel version. I don't have that option when I create a pivot table.

[jamespyle]

This is amazing, until you realize that the data model pivot tables suck and if you try to make anything advanced a lot of stuff will be broken.