Hiding columns

[Mur]

Hello,

Is there any way I can hid Actual and Forecast  columns from table below:

Category	Budget	Actual	Forecast	EAC (Actual+Forecast)
Sales	2	5	6	11
GP	3	40	3	43

My approach was to create Actual and Forecast as master items, Then EAC as another master item with expression like:

=[Actual]+[Forecast]

and then use it in my table, but I do not know why Qliksense does not accept 

=[Actual]+[Forecast]

and returns error?

[pravinboniface]

@Mur I think if you use Actual+Forecast as a master item dimension, you have to use it as a dimension in the table.  If you use Sum(Actual+Forecast) to create a master measure, you should be able to use it as a measure.

To hide a column from a table, can you not use something like this?

[Padma123]

use master measure 

name- EAC

expression-sum([Actual]+[Forecast])

by using show if hide the columns