Forum Discussion
Create a calculated field in pivot table based on values in multiple columns of table
I have a table with the following columns, Store #, State, Serial #, Manager, Date Serviced, Date Reported. I have created a pivot table that has rows of Manager and State, and columns o...
Thanks for the tip on Distinct Count and Data Model. I wound up just adding a "Measure" in the Power Pivot using =([Count of Date Serviced]/[Count of Serial Number])
