Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have dimension like this =Aggr([CustomerName],ProfitID)
and I have two expression 1 is sum(sales) and
2nd is sum({<{ Period='$(=max(Period)-1)'}>} Sales)
My requirement is i want to use =Aggr([CustomerName],ProfitID) dim for 1st expression and for second expression
i want to use just CustomerName
how can i do this?
Thanks
Gautham
Or just this?
If(Column(1) > 0, Sum({<Period={'2016'}>} Sales))