Pivot table colormix is not working when rolled up

[ashis]

Hi,

I am facing some issue using colormix , i have pivot table that shows me time of my jobs (written in expression) in days column
assiciated with my two dimensions in rows. I want to know which date it is taking more time to execute the jobs.
the following colormix code works fine if it is expanded . however when it is rolled up the color is not giving correct picture

folowing code i am using in expression ,

ColorMix1(Sum(yyy)/Sum(Total<Dimension1,Dimension2>yyy)/Max(Total<Dimension1,Dimension1>Aggr(Sum(yyy)/Sum(Total<Dimension1,Dimension2>yyy),Dimension1,Dimension2,Date)), ARGB(255, 99, 190, 123), ARGB(255, 255, 239, 156))

I want to make it dynamic so when it is rolled it shows correct as well as when it is expanded .

See the attached picture when it is rolled up

Now when it is expanded (showing only few lines just to give you an idea)

I want the color should work properly even if it is rolled up.

Please give your feed back.

Thank you,

[balabhaskarqlik]

May be add one more bracket:

ColorMix1((Sum(yyy)/Sum(Total<Dimension1,Dimension2>yyy))

/

Max(Total<Dimension1,Dimension1>Aggr(Sum(yyy)/Sum(Total<Dimension1,Dimension2>yyy),Dimension1,Dimension2,Date)),

ARGB(255, 99, 190, 123), ARGB(255, 255, 239, 156))

[ashis]

Hi Bala,

Thank you for your reply . It did not work putting one extra bracket.

Thank you.