Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
pick(1+match(Dimension,' & peek('AllDimensions') & '),sum(Sales),' & peek('AllExpressions') & ')'
This is a dupe post of PLS EXPLINATIN ABOUT THIS EXPRESSION?
Mods, please NUKE it.
my doubt is here what 1+ will do here
Hi manoj
Here
in peek('all dimension') what is the value you are getting?
May it will add with the value which is returned by match function