Brandon Schiwal on 19 Nov 2021 16:41:58
When using a Matrix there are times when I want to have categorical detail on the report. However, it doesn't make sense to have this information pass through to the subtotal or grand totals. It would be great if we could select which variables we wanted a subtotal/grand total.
This could be a switch to calculate "Only Numerical Variables" or even a drop down where we can select the individual variables and a switch to turn them on or off.
Having a 'First Description" on the top level or a high level of the matrix doesn't truly show the information that needs to be presented. Currently I am creating a measure to test if it HASONEVALUE() and passing a BLANK() if it is false. Doing this for all variables is quite tedious and there should be an easier method.