Hi ,
I got thsi syntax froma prior post .
rank( [Qty] DESC tuple [2020] within set [Territory])
this ranks my teritories on rows for 2020 by qty
say if i want to rank on multiple dimensions , I was not able to add some additional elements to tuple
like
rank( [Qty] DESC tuple( [2020] ,[Product1]) within set [Territory])
cant we add more members to tuple for the purpose , how would you handles this .
Thanks,