Hide Measure Column Pivot Table

[tumrong]

Hello, I am new to Qlik Sense. Can anyone please help me with this question. I am trying to hide column in the pivot table in Qlik Sense. Please see the picture. They are the columns in the circle I try to hide. Here is the command I use to create data in green column:

Sum(unit)/Before(Sum({<[Period]>}unit)) - 1

Is there any way to suppress columns in the circle.  These columns are the percentage change created from the above command. I need the current period to show and hide the prior period columns. Thank you for the help.

[rbartley · Accepted solution]

Unfortunately, there is no way to divide a cell and I do not believe that you can apply bold formatting either (at least not in the version I am using), so the best you can do is colour the whole measure as follows:

Add this expression to the text color property of the measure (again, changing the field names as appropriate):

if(Not(IsNull(Before(Sum({<[Period]>}[Shopper Total Spend])) - 1)),if(Sum([Shopper Total Spend])/Before(Sum({<[Period]>}[Shopper Total Spend])) - 1<0,red(),green()))

You can use the same approach to change the background.