Colormix and Pivot problem

[dadadadadada]

Hi there!

I have:

Horizontal Dimension - MonthYear

Vertical Dimensions - YearSignUp, MonthYearSignUp

My Color background expression:

WORKS FINE: ColorMix1( column(columnno()), rgb(255,255,255), rgb(0,96,11))

DOES NOT WORK: if(Columnno()=1, red(), ColorMix1( column(columnno()), rgb(255,255,255), rgb(0,96,11)) )

Questions:

1) It seems that Colormix does not work in conjunction with IF, right? My desired formula is actually more complicated (i want another Colormix instead of red() )

2) Is it possible to change the representaiton of the Horizontal dimension (MonthYear)? I want 0, 1, 2, 3 etc. instead of MonthYear.

Please, help

My Measure (in case it matters):

if(ColumnNo()=1,

// Formula for the first Column

num(

count(distinct {<

First_Purchase={'1'},

>} total <[MonthYearSignUp]> OrderN)

,'# ##0')

// Formula for rest of Columns

,num(

after(total

count(distinct {<

>} OrderN)

,(YearSignUp-min(total [YearSignUp]))*12+num(month([MonthYearSignUp]))-1   // this is dynamically changes based on the number of rows with MonthYear

)

/

count(distinct {<

First_Purchase={'1'},

>}  total <[MonthYearSignUp]> OrderN)

,'0%')

)