static grand total in matrix when filtered
Hi, I have a matrix with different countries as rows and Value (USD) as values. If I filter on a country, I want to keep the grand total unchanged. So in this case, if I filter on Zambia, I want it to show 103.55 for Zambia and 287,524.39 for Total. Is it possible?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 ?
