Is it possible to use an expression as calculated dimension when expression itself was calculated using AGGR as dimension. I want to use Decile as calculated dimension for further analysis. Expression behind the decile is ( I have attached the application for reference)
10-(div(((RangeSum(above(TOTAL sum(OrderCount),0,RowNo(TOTAL))))/sum(TOTAL OrderCount))*9.99999999999,1))
Can you help me create 'Decile' from this application as calculated dimension? Thanks.