In this data, Columns A:F data are repeated each quarter when new sales come out. I want to be able to find information about those columns in the pivot table. For example, the company has 2 accountant positions but since the data is repeated 10 time, "Count of Position" returns 20. What would be the formula for a calculated field that would do this.
Bookmarks