Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
I am using the below diamension for chart , all work fine except YearMonth display as number :-
Pick(Match($(Var_P),1,2,3,4,5,6,7,8,9,10),year,Quarter,YearMonth,SEGMENT,SEGMENT_,REGION_,COUNTRY,GROUP_CLASS,company)
it there any work around ?
Paul
Rather than using Pick(Match()), have you considered using a drill group or a cyclic group. Add all the dimensions fields to the group and use the group as the chart dimension. Use a drill group if there is a hierarchical relationship between the fields, or a cyclic if there is not.
Hi jonathan
Thank you vey much for the alternative , may i know does QS support cyclic group ?
I aware QV does have cyclic group. but not sure in QS.
Paul
Perhaps not - I have not invested a lot of time on QS