Qlik Sense Pivot Table - Show column (measures) if selected Month

[surtex]

Hello together,

i would like to create an Pivot Table like this :

I would like to show all values until the selected Month above and must use the following field:

Show column, if..: which formula I need here?

I must create a measure for each month because I need in addition to the month values three other (non monthly) values... 

The expression for each Month is: 

Sum({<Profit_Center_COPA = {'185', '186', '187', '188', '189', '152','194'}, Scenario = {'Actual'}, Year = {"=Right(Datumsfilter,4)"} , MonthNbr={'1'} ,Datumsfilter={"<=$(=max(Datumsfilter))"}>}"EBIT adjusted")/1000

My permanent filer names "Datumsfilter"... 

Can anybody help me? 

Thanks 🙂 

[rubenmarin]

Hi, so you only need to know what to set in 'Show column if'?

If you have a month selector, and the field iscreated with the month() function, wich creates a Dual value (it's a string and a number at the same time), you can use:

For feb: Max(Month)<=2

For mar:  Max(Month)<=3

Etc.