Pages

Thursday 25 July 2013

Distinct Counts & more in your Pivot

If you are really quiet, you can hear an analyst in your company screaming with joy once they realize that in Excel 2013, you can get distinct count of values in pivot reports!!!
Distinct counts in Excel 2013 pivot tables
That is right, using Excel 2013 pivot reports, you can find out distinct counts. No extra formulas or no arrays or no VBA.

No comments:

Post a Comment