Forum Discussion

lawada's avatar
lawada
Icon for Helper III rankHelper III
5 years ago

removing subtotal for specific field in matrix

i created a matrix  that shows for each laundry : total orders, revenue, arrow indicator trend per month

 in the rows i have :

-Laundry Name

-MonthYear 

 

and in the values i have  :

-successful orders

-orders arrow indicator

-total bill amount

-bill  arrow indicator

 

im getting subtotals for all the values i have but i want the subtotal to be hidden/removed for the arrow indicator only.

i used the function (hasonevalue) which has worked but one issue is that if a laundry has a value for one month , the subtotal for arrow indicator will be shown.

example :

 

how can i remove the subtotal for the arrow indicator value only , even if it has one value ?