So I was playing around and was able to hide the values for Marking and Total Expenses for "Tea" by using this formula:
IF [Product Type] = "Tea" THEN 1/0
However, Marketing TEST and Total Expense TEST column headers under "Tea" are still showing. Is there a way to hide those column headers without impacting the column headers and values under "Coffee"?
Measure Values Test_V1.twbx 342.3 KB