Forum Discussion

ERing's avatar
ERing
Post Partisan
3 years ago
Solved

Is Custom Subtotal in Matrix Visual possible?

Is it possible to create a custom subtotal line in a matrix visual? In the example below (taken from the web) I would want to create a subtotal for Camcorders, Cameras & Camcorders Accessories, and...
Need Help
  • lbendlin's avatar
    lbendlin
    3 years ago

    There are multiple ways to accomplish this.  The safest would be to add another category level.

     

    Otherwise read about ROLLUPADDISSUBTOTAL()

lbendlin's avatar
lbendlin
Super User
3 years ago

There are multiple ways to accomplish this.  The safest would be to add another category level.

 

Otherwise read about ROLLUPADDISSUBTOTAL()

ERing's avatar
ERing
Post Partisan
3 years ago

lbendlin Adding another category level can be done in PowerQuery, right? I would add a conditional column that defines the 3 subcategories as a single category?

  • lbendlin's avatar
    lbendlin
    Super User
    3 years ago

    correct. you can also do that in DAX if you want, or via Groups.