Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Albert2
Contributor II

ColorMix in PivotTable

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')

5 Replies
brunobertels
Master

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
Contributor II
Author

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
Master

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
Contributor II
Author

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
Master

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