How do I add a total to a column when I added a Beast Mode?

kim_barragan0126
kim_barragan0126 Member
in Beast Mode

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

image.png

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?

image.png

Categories