How to sort a measure by dimension within a table/bar chart

[EdyTan]

Assuming I have the following data:

type	row	value
1	A	10
1	B	20
1	C	30
1	D	40
2	10	50
2	11	60
3	Total	100

Is it possible create a table/bar chart which sort by type followed by sum(value).  The result is like this:

row	sum(value)
D	40
C	30
B	20
A	10
11	60
10	50
Total	100

[EdyTan]

found a way, is to sort by expression, descending, (4-type)*999999999+sum(value)

and the chart will look like this