Forum Discussion

PowerUser123's avatar
PowerUser123
Helper II
3 years ago

Matrix - Show Calculation only as a Total

I have a matrix where I'm showing months of the year as columns.   I need a measure to only show up in the Total rather than for every single column.    I know the workaround of ISBLANK, but that...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Community Champion
3 years ago

PowerUser123 Try:

Measure =
  VAR __Count = COUNTROWS('Table')
  VAR __CountAll = COUNTROWS(ALLSELECTED('Table'))
  VAR __Return = IF(__Count = __CountAll, <total value goes here>, BLANK())
RETURN
  __Return
PowerUser123's avatar
PowerUser123
Helper II
3 years ago

Greg_Deckler 

 

Appreciate the reply. So I believe that measure makes the measure blank across each month and appear in the total section correct?

 

I have a solution such as that implemented, but to me it's not optimal and was wondering if there are any other solutions.

 

The reason why it doesn't work for me is that I need to display the measure name in the total section (Vs Prior Month) and can't make it blank to have the column be automatically small across the months.

 

This is what my table would look like:

So the measure above would work because it displays blank per month but appears in the total. However, I need to manually drag and make the Vs Prior Month column disappear for each month. I was wondering if there are any solutions that prevents me from having to do that step. As the current solution isn't really deployable as each new month appears, someone has to manually go in and drag the column so it doesn't appear.