Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Customize matrix subtotals

Hi there!   I'm currently struggling with a report that should calculate the bonuses for our Salesteam. This bonus consists of 3 items (Bonus UNI, Bonus UNF & Bonus PA). These 3 items are summed, w...
Need Help
  • Icey's avatar
    Icey
    4 years ago

    Hi Anonymous ,

     

    Try to create another measure like so:

    Bonus ALGEMEEN TOTAAL (na eval.) 2 =
SUMX (
    VALUES ( 'TUSSENTABEL COLLEGA''s'[Naam collega] ),
    [Bonus ALGEMEEN TOTAAL (na eval.)]
)

     

     

    Best Regards,

    Icey

     

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

Icey's avatar
Icey
Community Support
4 years ago

Hi Anonymous ,

 

Try to create another measure like so:

Bonus ALGEMEEN TOTAAL (na eval.) 2 =
SUMX (
    VALUES ( 'TUSSENTABEL COLLEGA''s'[Naam collega] ),
    [Bonus ALGEMEEN TOTAAL (na eval.)]
)

 

 

Best Regards,

Icey

 

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