Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

NA

  • Anonymous's avatar
    Anonymous
    5 years ago

    HI Anonymous 

    You can use matrix chart instead and use "Sum" for net revenew.

     

     

    If you want to use a formula then

     

    CALCULATE(SUM(table[net revenew])),ALLXCEPT(table,table[product],table[month]))

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    HI Anonymous 

    You can use matrix chart instead and use "Sum" for net revenew.

     

     

    If you want to use a formula then

     

    CALCULATE(SUM(table[net revenew])),ALLXCEPT(table,table[product],table[month]))