I added a Beast Mode so I would only get the Fee to list once since the Position ID is listed multiple times. I need to see each line so I can have a count on how many candidates per position. have I used - SUM(DISTINCT Fee
). It works great, but how do I now get a total for the column?
Raw Data
This is the pivot. Everything looks great except the Grand Total. I want the "Test Fee" to have a correct Grand Total. Can this be done?