Pivot Table Grand Total

JasonKerr
JasonKerr Member
in Cards, Dashboards, Stories

When I add the "Total Row" to a pivot table, it does not always show the "Grand Total". If the column has an aggregation applied, then the Grand Total shows the aggregation (Average, Maximum, Minimum, etc.) instead of a Total.

Is there a way to show the actual "Grand Total" (aka the sum of the values) rather than the aggregation?

Best Answer

Answers

  • MichelleH
    MichelleH Coach
    Answer ✓

    @JasonKerr Try using a FIXED function in your beast mode and put your row and column fields into the FIXED BY clause.

    Here is an article on FIXED functions: https://domo-support.domo.com/s/article/4408174643607?language=en_US

  • JasonKerr
    JasonKerr Member
    edited August 8

    @MichelleH This wouldn't work in a pivot table, right? Adding any new "value" fields will have them show up in each segmentation of the table. I am only looking to add one row at the bottom of the table with a total of the values in the columns.

  • MichelleH
    MichelleH Coach

    @JasonKerr I mean to use the FIXED beast mode in place of the existing value field. By using the FIXED aggregation, you are dictating how you want the grand total row to calculate instead of the default aggregation.

Categories