Add total row

Question

Hi Team,

I need help in creating a total row in my dataset. Below are my data set.

SectorJan_2025Feb_2025Mar_2025Apr_2025May_2025Iron1012 55 Steel201005 08Power301517  Coal 182210

Now I want total at the end. Refer the below data. Point to be noted here is that:
      a) sector list may increase or decrease 
      b) months name and year will keep on changing, once we will get new data
      e) Also, I need a blank row between my sector and my total row.

SectorJan_2025Feb_2025Mar_2025Apr_2025May_2025Iron1012 55 Steel201005 08Power301517  Coal 182210       Total6046446508

JosephSerpis · Accepted Answer

Hi @akumar2609 adding a Total Row that is dynamic is relatively easy you can use a combination of a Transpose Tool and then Crosstab tool to sum your data and add a Total row as both are options in the configuration of the Crosstab tool. Adding a blank row adds a bit more complexity in the example I shared I'm add a blank row via a Text Input and then using the configuration of the Union tools to set a specific order so a blank row appears above the Total and then blank row and total appear below all the data.