trying to suppress rows on values as rows in a matrix

[bsheffer]

I have a matrix

                             month1 |  month2 | month3 | etc

day | value1        sum(value1)

       | value2        sum(value2)

they are linked to a common date table so for each day of each month I have a sum by day for value1 & value2. 

I'm using values on rows to bring the columns to the rows

The problem is that value2 only has 1 date per month (1/1/2022, 2/1/2022, etc.).  So my result is  each day has 2 rows but, except for the first day of the month, the row with value2 is blank except for the row header of value2.

how do I suppress the row for value2 if it doesn't have a total for that date?

here is the field settings:

value1 = IC Billing (calculated daily)

value2 = Merchant Income (calculated once a month with an activity date of the first of the month)

[amitchandak]

@bsheffer , If that is a measure I doubt you can suppress. Try creating a calculation group of the measure and check if it serves the purpose

Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display: https://youtu.be/qMNv67P8Go0

[bsheffer · Accepted solution]

I ended up creating a new table with the 3 values I needed and created a matrix from that new table.