Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
I have 3 monthly trend charts Costs, Benefits and Checks and respective filters.
When i select a Check Type in filter then sort order of Month Dimension in other 2 charts is altering when compared to initial state.
but, this is not happening when i select other 2 filters.
I couldn't figure it why its happening.
P.S: Month, Year are Synthetic keys
Please find the attachment.
Help is much appreciated
Thanks
sort MonthName by numeric value (remove the other sort)
Hi Maxgro,
Its like that, still causing problems.
Thanks
I get this selecting Check Type. If it's not correct, what do you want to achieve?
I see the difference in mine. if i select same thing. See Benfits charts. Can you confirm me that other 2 charts are not changing the sort order select differt Check Type
Hi,
The problem is not into it is the data.
Evidently not having data for all months of every year, the selection of a Check Type, the costs are shown in alphabetical order, but always by Year.
How to Use MonthYear size should solve
Regards
Gennaro
Thanks Gennaro.
I cant use MonthYear, because if there are many year the chart looks weird.
Is there any solution except this with the same data?
Yes you can use the number of Month.
Will give a try
Thanks
It didn't help. because it also associated with MonthName.
Thanks