It should work as you expect.
Did you change data or add the formula after creating the table ? Just in case, remember that the pivot table has to be updated after changes have been done to the source data, and this is not done automatically (unless you have some VBA code to do it for you).
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!
Discuss This Question: 2  Replies