Forum Discussion
remove total from row level
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
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.
Hope this helps.
Thank you,
Vishesh Jain
2 Replies
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.
Hope this helps.
Thank you,
Vishesh Jain
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.
