Forum Discussion

SAGUILAR's avatar
SAGUILAR
Frequent Visitor
2 years ago

Only the total column

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.

 

General Comment
Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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's avatar
      SAGUILAR
      Frequent Visitor
      2 years ago

      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!!!