Sorting of latest 4 months data in bar chart using dimensional limits

[Anonymous]

Hi All,

I am trying to display latest four months data in a bar chart and my sorting is not properly working. Currently it is getting displayed as shown below. But I need the monthyear to be displayed in right to left descending

What I am doing currently doing is

Create a monthsort field as below

year(TempDate)&num(month(TempDate),'00') as monthsort

Use monthsort field for sorting

Show only first 4 values in dimensional limits as below

How to make this sorting proper Nov-17 on right hand side . Please suggest

Thanks and Regards

Praveena

[vinieme12]

can you post the full screenshot? just to make sure you don't have anything else check except Sort by Expression for Month field and nothing for region field

also try below

NUM(year(TempDate)&(month(TempDate),'00')) as monthsort

[dinuwanbr]

Hi,

Instead of first 4 select largest 4 in limit dimension and sort ascending order.

PFA

Rgds,

Tharindu

[Anonymous]

HI tharindhu and Vineet

Thank you fr your prompt response

Setting largest values gives me something like below

Nov, Oct missing as Largest will take the largest will return the values based on first expression in the chart. My Nov. oct values are smaller than other months data and it is missing

[dinuwanbr]

Hi,

Can u upload a sample.

Rgds,

Tharindu