Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have created a cyclic group including a couple of columns and added as a chart dimension,
I like to show these columns in group in a way user would recognize them, i know i can rename them by Load or Qualify ... but isn't there any other way to set a label alike?
Thanks
Hi Arman
Sorry I haven't logged in for an while. Please see below this should work. in my example monthnumber is the field name, replace this with A1
if(MonthNumber ='1','Highly Aggreeable',
if(MonthNumber ='4','Aggreeable',
if(MonthNumber ='9','Not Aggreeable',
MonthNumber )))
Thanks and regards
PAdma