Sort on column which contains images

[#1]

See below example of the pivot table. I wan't to sort on column 'Movement'. When I click on the red arrow of year '2012', crop 'Tomato' I want to see only the records of Tomato and Corn Salad. How do I realise this? Ditto for the other arrows or '-'.

	Year 2012					Year 2013 (ditto 2012)
Crop	Forecast Year To Date	Invoiced	To go	Realised%	Movement	Crop	Forecast YTD, ditto..
Tomato	1.500	0	1.500	0%
Cumumber	2.000	2.000	0	100%
Onion	900	1.400	- 500	155%
Spinach	0	300	-	-	-
Corn Salad	1.600	200	1.400	12,5 %

Content of properties column 'Movement', tab Expressions, Definition:

If(Realised% = '-', '-',
If(Realised% < 0.95,'qmem://<bundled>/BuiltIn/arrow_s_r.png',
If(Realised% < 1.00,'qmem://<bundled>/BuiltIn/arrow_e.png',

If(Realised% = 1.00,'qmem://<bundled>/BuiltIn/arrow_ne_y.png',
'qmem://<bundled>/BuiltIn/arrow_n_g.png')))) 

(Grey arrow not shown as example in the table)

[#2]

Hi,

I would say you need "Movement" to be a Dimension if you want to achieve this...

Alternatively, you could also create buttons with the logos out of the chart that selects the right %Realised data somehow.

[#3]

Thanks for your quick reply. Field 'Movement' as a dimension doesn't solve my problem. I'm trying to make buttons for the sorting, but It looks like this only works with dimension fields. Is this right of are there other possiblities?