Pivot Table COUNT DISTINCT Employee

[SalimJ]

Hi,

I have a Excel list for Sales data with 1 record per salesman/period.

I have created a pivot table in compact form from that list where in the Report Filter section, I have the period (year/month). In the Row Labels section, I have Cluster/Dept/Salesman. In the Values section, I want to display #Salesman, Total Sales, etc.

What I want to do is: whatever the number of periods I choose from the Report Filter, the #Salesman must display the correct number of salesmen. Actually, it is displaying the number of salesmen * the number of periods.

Any idea on how to solve this problem.

Many thanks.

Regards,
Salim.

 

[Luke M]

I'm having trouble visualizing your request. Would it be possible to post a sample file or image?

 

[SalimJ]

I'm having trouble visualizing your request. Would it be possible to post a sample file or image?

Thanks for your prompt reply Luke M.

I am uploading a sample file to illustrate what I trying to do.

I want to have the same number of employees even if multiple periods are selected.

Thanks.

Best Regards,
Salim.

 

[SalimJ]

Dear Luke M,

I have uploaded the sample file and got an error message.

I'm not sure whether it has been uploaded as I don't know how to check.

Could you please help.

Many thanks.

 

[bobhc]

Good day SalimJ

If you look at the bottom of the dialogue box where you type your problem you will see a "Upload a File" button just find the file on you computer select it and confirm, it will show just below your post in the forum.

http://chandoo.org/forum/threads/file-upload.11644/

not sure what you mean by "pivot table in compact form"

 

[SalimJ]

Greetings bobhc,

The file has been uploaded. There is the option compact / tabular format for the pivot table. I'm using the compact format.