Pivot Table: Count Distinct :Totals Error

[Purushothaman]

Hi There,

Below is my dataset and attached is the QVF.

My Requirement is to count distinct MeetingName under the Column of Type of Meeting. 

When calculating the Count distinct MeetingName under the Column of "Type of Meeting"in pivot table.

The Total is showing 1, however I want the Total to show it as 2.

Because the Meeting Name  which is "Zone5" appeared in both Types of Meeting which is "Email" and "Physical". 

Anyone, Please help me to resolve it. Thank you!

[Or · Accepted solution]

If your requirement is to count the distinct number of meetings, that was one meeting, and it should be 1, not 2.

If your goal is to count the number of distinct meetings and location combinations, count(distinct MeetingName & [Type of Meeting]) should work.

[Purushothaman]

@Or 

WOW!!! You made it super Quick and Easy!!! 

Many thanks for your help!!