Only the total column

[SAGUILAR]

Hello,

I've been trying to add the TOTAL Value $$ column to the table above, but I'm getting the total value for each group (A-F). Is there any way to add just one column? I need one column.

[v-binbinyu-msft]

Hi @SAGUILAR ,

In order to better understand your demands and give the right solution, could you please provide some more specific information? such as your desensitized example data and a screenshot of your desired results?

Thanks for your efforts & time in advance.

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[SAGUILAR]

Sure, I prepared the following tables in Excel of the expected result in PBI. I have a table organized by Division and Groups (units), the goal is to add the column $ Total Value (Blue) next to the column Total Units. If I do that in PBI I will have a column of $ Total Value for each group (second screenshot). I would like to see the total at the end only not by groups.

Expected result in PBI

Actual result.

I hope this helps. Thanks!!!