sort order will be changed after selection

[Masi_Sahargahi]

Hi all,

I have a line chart which shows  cumulative sum of price for each month, (For 2018 ,it shows just 5 month which we have data for them).

The problem is :as I specified  year with set analysis, I don’t expect chart changes after select any year, But when I select a year, my chart order will be changed! Can anybody help me out if this.

[Anil_Babu_Samineni]

Reload this?

[Frank_Hartmann]

2 things to change:

1: Add expression: =avg({1}1/1) and make it invisible

2: Sort Expression: MONTH_NAME

[Masi_Sahargahi]

NO need to reload

I couldn't download the file,have you made any change in my file?

Please reply on the main link,then I'll remove the thread..

[Anil_Babu_Samineni]

Instead, Can you just use this as expression from sort TAB and test?

Only({1} MONTH_NUMBER_OF_YEAR)

If not, Will share script which i changed