Customer Group No Count Automatic in Pivot

[Nitin Shardul]

Sir,
Unable to count no of customer result
attached sample file

regards,

N3

 

[Nebu]

Hi:

Find the attached, using power pivot and DAX.

Thanks

 

[Nitin Shardul]

Thanks Unable to open which excel version are you using?
Regards,
N3

 

[Nebu]

Hi:

I am using excel 2016, should not be a problem for you if you have power pivot in your excel.

Thanks

 

[GraH - Guido]

If you can't use DAX/Powerpivot, an older trick is doing a pivot on the pivot.
It can be invoked by using ALT+D+P -> select range of first pivot and then create a new one.

Example attached. It is not ideal, if possible I suggest to evaluate if PowerPivot can be installed as add-in in your Excel version, if it is not already build in. As of version 2010 (for Win OS).

 

[Nitin Shardul]

Well Noted Sir,
Thank you
N3