I wanted to try and use valuelist inside an aggr if function...this didnt work. My expression looked like this
Aggr(if(CostCentreType='Operations',Valuelist('Revenue','Cost of Sales','Margin','Margin %'),Valuelist('EBIT')),CostCentreType)
What I am trying to achieve is that if CostCentreType (It has been added as a dimension) is 'Operations', then use the first valuelist, if CostCentreType is something else use the 2nd Valuelist which is just 'EBIT'
Any idea how to get this to work and where I am going wrong