ColorMix in PivotTable

[Albert2]

Hi,

I want to highlight values in a pivot tabl.

Now i have function colormix1 but they is only referencing on each single row:(

This is my secend  function, but dosn't work 

colormix1(count(e_sale_amount)/max(total aggr(count(e_sale_amount),[calendar.month],[item.plan_category_name])),LightRed(),yellow())

dimesions row =[item.plan_category_name]

dimension columns =[calendar.month]

measures =NUM($(e_sale_amount), '#.##0')

[brunobertels]

Hy 

may be one of this should work 

ColorMix1( hrank(total column(1))/NoOfColumns(TOTAL) , lightred(),yellow()) //  ( should highlight by column) 

ColorMix1( rank(total column(1))/Noofrows(TOTAL) , lightred(),yellow()) // should highlight by row ) 

hop it helps 

[Albert2]

Thx 🙂

It is posible highlight by all value of table?

Highlight by row and columns works properly but it is not enough for me 😞 because I compare data from all table area.

I will be thankfull for helping. 

[brunobertels]

hi 

in this case we should use the colormix function with the mesure rather than rank() and noofrows()

And in that case your first expression should work : 

colormix1(count(e_sale_amount)/max(total aggr(count(e_sale_amount),[calendar.month],[item.plan_category_name])),LightRed(),yellow())

as it compares each e_sale_amont with the max e_sale_amont 

Sorry a may miss something 

regards 

[Albert2]

ok, is working good 🙂

Now i have one questions more.

I have pivot table with two rows dimension , one is optional, the kolumn dimenion is also optional. 

Do u know how to change this expression?

My dimmensions:

$(g_dimension_2) 

$(g_dimension_calendar_3)))

[customer_type_group.name]

[brunobertels]

Hi 

not sure to understand your need 

it seems that 

$(g_dimension_2) 

$(g_dimension_calendar_3)))

are variable and calculated dimentions ? may be you have a button to split between dimension ? 

can you elaborate a little bit more your context and desired output 

regards