
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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')


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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]


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
