Decomposition tree totals

[ksab23]

Hi all, any advice on whether I can make the last column of my decomposition tree show total value instead of breaking it down to categories (3 kids won 0 USD coupons, 1 kid won 0.45 USD coupon, etc.)? I need it to show 10 USD or whatever the actual total is. I was thinking that I might need a formula for it but I wouldn't know to build it, since there are other categories as well - Won, Lost, and Pending, and for each, I need the total summed amount of coupons.

Thanks a lot!

[MFelix]

Hi @ksab23 

This can be done using a dax measure but that would show the same value in all of the values (in this case 3) also be aware that you cannot control if the calculation is on the last level of the tree, meaning that if the category you use for that specific calculation is put on the second place of the tree you will get the 10 on the second place not on the last one.

Another question that I have is do you want to still have the split or do you want to have a single valuefor that specific column of the tree?