Change Defaults For Pivot Table Summary

  • Hi All,

    Apologies but this question of mine was not here it is again...

    When I open my Pivot Table Wizard, the DEFAULT for the summary measures in the data area is set to SUM.

    How do I change the DEFAULT to COUNT so whenever I use the wizard, COUNT instead of SUM appears for my summary measures.


Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!