Difference between two Categories value - Matrix Table

[DKM_83]

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 App-Web values.

kindly advise me.

Thanks

DK

[Ritaf1983 · Accepted solution]

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