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

user04693
user04693 ⚪️
in Magic ETL

Hi,

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.

Comments

  • ST_-Superman-_
    ST_-Superman-_ 🔴

    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
    ______________________________________________________________________________________________

Categories