Forum Discussion

DKM_83's avatar
DKM_83
Regular Visitor
2 years ago
Solved

Difference between two Categories value - Matrix Table

Hi Team,   I have created Matrix table and wants to show difference between two cateories values.   The below table Catefories for App and Web is single column and wants to show Diff column is Ap...
Need Help
  • Ritaf1983's avatar
    Ritaf1983
    2 years ago

    Hi DKM_83 
    You can create 3 measures and use them, as "values".
    (you don't need to put anything in "columns")

    1. For app
    App = calculate( sum('your table name[your value column]), 'your table name[category] = "App")
    2. For Web
    Web= calculate( sum('your table name[your value column]), 'your table name[category] = "Web")
    3. For diff 
    Diff = [App]-[Web]

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

Ritaf1983's avatar
Ritaf1983
Super User
2 years ago

Hi DKM_83 
You can create 3 measures and use them, as "values".
(you don't need to put anything in "columns")

1. For app
App = calculate( sum('your table name[your value column]), 'your table name[category] = "App")
2. For Web
Web= calculate( sum('your table name[your value column]), 'your table name[category] = "Web")
3. For diff 
Diff = [App]-[Web]

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