Change Defaults For Pivot Table Summary

    Hi All,


    Apologies but this question of mine was not answered...so 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.


    Thanks,
    Jason

Participate now!

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

Register Yourself Login