Adding percentage to total but cannot apply a 'Sub Total' in table


I have added a beast mode to calculate the % of the total in the table (refer to far left column).beastmode.PNG












Beast mode formula: SUM(`EP`)/SUM(SUM(`EP`)) OVER ()

However, it now gives me an error when I insert a sub total in the table.

beastmode error.PNG

How can I fix this issue so it can show the sub-total or total row in the table?

Thank you.


  • My first thought is to perform the percent calculation in the dataflow.  However, then the calculation will not change with any filters applied to the card.  

    “There is a superhero in all of us, we just need the courage to put on the cape.” -Superman