Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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.
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.