remove total from row level

[goyalsa]

Hi all,

I create a calculated field [ _Benchmark = CALCULATE(DISTINCT(AllOrders[Export Target Sales])) ] but I want the total shows at the end of the "Region To" level instead of the "country To" level.

Any help would be appreciated!!

Kind regards,

Sahil Goyal

[Anonymous]

Hi @goyalsa 

If you want to turn off the row total you don’t need , you can set it in Subtotal => Per row level => Country To .

Best Regard

Community Support Team _ Ailsa Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[visheshjain · Accepted solution]

Hi @goyalsa ,

I don't know how your data and hierarchy are structred, but please have a look at the following video and see if it helps you.

https://youtu.be/YtIdcCYnZ9w 

Hope this helps.

Thank you,

Vishesh Jain