Excel pivot table subtotal

[santiago_Alvarez (Santiago Álvarez)]

Good day, I am using the modern activity of creating a dynamic table, in the properties I am using the tabular option so that it is divided into columns and not compact, however I get totals for each row which causes the information to be repeated. Is there a way to remove that subtotal from the bot? Attached image.

[pravallikapaluri]

Hi @santiago_Alvarez

Check the Below thread,It might helps you.

Removing Subtotals from Pivots

In which activity you are using this code @yash.choursia You have to use this code in Invoke VBA Activity which is the Excel activity, you have to use this activity inside the Use excel file activity. Store the code in .txt file (Notepad file) and pass the the path of the .txt file in Code file path field. Pass the Method name in the Entry Method Name field. Check the below image for better understanding, [image] Notepad file - Working on Pivot Tables.txt (547 Bytes) Hope you understand…

Hope it helps!!