Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Change your sort expression to ignore the Year:
=only({<CALENDAR_YEAR=>}MONTH_NUMBER_OF_YEAR)
-Rob
Don't create duplicate threads sort order will be changed after selection
2 things to change:
1: Add expression: =avg({1}1/1) and make it invisible
2: Sort Expression: MONTH_NAME
But it doesn't work for me,I expect sort order as follow:
Jan,Feb,march,..
Change your sort expression to ignore the Year:
=only({<CALENDAR_YEAR=>}MONTH_NUMBER_OF_YEAR)
-Rob
But what I want is showing value for different months of max year and its previous year
It did work,thank you so much!