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 order doesn't change (all charts are only sorted by numeric value)
The number of months displayed change (if you always want all months check show all values in dims and uncheck suppress 0 in presentation)
Also if you use a month dimension, with 2 years (2014 and 2015) the expressions is the sum of 2 years