Sorting in a bar chart

[#1]

Hi All ,

i have a trend graph on a bar chart , were i am uploading 3 months of data . i would like to sort data on the basis of last uploaded month data.

for example : i am uploading data for october , november and decemeber . now i need to sort data on the basis of december data and i need to show respective november and october months data .

hope this information helps.

[Anonymous]

Sort by numeric value descending

[#3]

i am not getting the right answer when i sort by numeric value . let me more clear .

i have two dimenions . product and month and expression is count of product . i am also following up with an example . i need my chart to display exactly like the one in below graph which i created in excel

	Oct	Nov	Dec
A	55	10	60
C	12	22	45
B	15	20	30
D	80	10	20
E	20	100	10

[Anonymous]

PFA

Hope this helps

[#5]

as far as i see , the qvw file which you sent . the sort is done on state = ascending order . but i dont see my data is sorting still on basis of highest last uploaded month(December highest number ).

please check the picture which i presented here

[Anonymous]

Make a variable to store the value of the latest month. lets say december. Then use this expression in sort by expression set to descending value for Product.

=Count({<Month field name= {"$(Variable name"}>}Product)

[Anonymous]

Hi adithya,

Check this

[#8]

hi vignesh , could you please  just give me the sorting expression or the logic . i dont have a licenced version

[#9]

i utkarsh i created a variable using vmonth= Month(AddMonths(Today(),-1))  and i am getting month has dec , but when i am giving in the expression i am not getting the right value

if i am right , i used that sorted expression in expression tab , if the expression i am using is right

=Count({<Month field name= {"$(vmonth"}>}Product) , i should get only december month data right ?

please correct me if i am wrong

[Anonymous]

Count({<Month field name= {"$(vmonth)"}>}Product)

You missed a bracket there (after vmonth)