Hide value columns on Pivot Table

[AlejoCumpa]

I want to aggregate three types of values, but only one in each column, like this: 

Currently  I am achieving it with two pivot tables, the right one behind the bigger one, like this:

With the three aggregate values would be : 

       

So I want to have that totals and subtotals but in columns only the USD values and not three of them.

[parry2k]

@AlejoCumpa you can change your measure to suppress the total

Suppress Total =
IF ( HASONEVALUE ( Table[Gastos Area] ), [YOur measure DAX Expression here] )

Check my latest blog post Comparing Selected Client With Other Top N Clients | PeryTUS  I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡