Forum Discussion
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 Digital Cameras.
Is this possible?
So the totals in this example would be.
Subtotal: Camcorders, Cameras & Camcorders Accessories, and Digital Cameras.
Digital SLR Cameras:
Total: Camcorders, Cameras & Camcorders Accessories, and Digital Cameras
There are multiple ways to accomplish this. The safest would be to add another category level.
Otherwise read about ROLLUPADDISSUBTOTAL()
4 Replies
There are multiple ways to accomplish this. The safest would be to add another category level.
Otherwise read about ROLLUPADDISSUBTOTAL()
I use the ProfitBase visual to add custom subtotals.
Store Link: https://appsource.microsoft.com/en-us/product/power-bi-visuals/wa200000642?tab=overview
