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

kim_barragan0126 · 2024-10-14T20:27:45+00:00

There was an error rendering this rich post.

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?

Find more posts tagged with

Accepted answers

Craig_Lynch

Hi Kim,

Maybe there's something to this that I'm missing, but the Distinct would be causing the grand total to only sum the unique values within the list.

By having the Position ID displayed, you should just be able to aggregate(sum) the Fee column and it would give you the result you're after.

Ajeet Mahajan

Thanks for reaching out to our community forum.

In most data visualization tools, it's generally not possible to combine distinct values and overall totals within a single column in a pivot table or similar structure.

Here are the common approaches to achieve this:

Separate Columns: Create two columns: one for distinct values and another for the overall total (Please see the screenshot below). This provides a clear separation and allows for easy analysis.
Summary Card: Use a summary card to display the overall total separately from the detailed pivot table. This can be placed above or below the pivot for easy reference.

All comments

Craig_Lynch

Hi Kim,

Maybe there's something to this that I'm missing, but the Distinct would be causing the grand total to only sum the unique values within the list.

By having the Position ID displayed, you should just be able to aggregate(sum) the Fee column and it would give you the result you're after.

Ajeet Mahajan

Here are the common approaches to achieve this:

Separate Columns: Create two columns: one for distinct values and another for the overall total (Please see the screenshot below). This provides a clear separation and allows for easy analysis.
Summary Card: Use a summary card to display the overall total separately from the detailed pivot table. This can be placed above or below the pivot for easy reference.

kim_barragan0126

Thank you for the responses! I was able to create the below Beast Mode which solved my issue.

SUM(MAX(Fee) FIXED (by Position ID))

Ajeet Mahajan

Great!

I apologize for the misunderstanding. It seems I misinterpreted your use case. I thought you wanted to display a unique row for each position ID with its corresponding fee, along with a grand total for the overall fees.

I'm glad you were able to find a solution that works for you!