I have a pivot with 3 dimensions and a bunch of expressions. One of these expressions is a "flag" of days that is colour coded (below 14 days give me amber). I would need to sort this table if this flag comes up (if the colour applies). Any ideas?
Hi Imi, if color expression doesn't depends of dimension values, you can use the color expression as sort expression, just instead of assign a color it gets a number to order, ie:
=If(DateField-Today()<14, 1, 2)
Retrieving data ...