Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have a straight table with
dimension = Region
expression = aggr(rank(sum({<Date={'>=$(LTM)'},Customer=>}Revenue)),Region,Customer)
This gives me a revenue rank of a selected customer for each region. However, in the total row at the bottom, I want to show the revenue rank of the customer in total, without region taken into account. The "expression total" option returns a null value. Any ideas?
May be try this
If(Dimensionality() = 0, Aggr(Rank(Sum({<Date={'>=$(LTM)'},Customer=>}Revenue)), Customer), Aggr(Rank(Sum({<Date={'>=$(LTM)'},Customer=>}Revenue)), Region, Customer))
May be try this
If(Dimensionality() = 0, Aggr(Rank(Sum({<Date={'>=$(LTM)'},Customer=>}Revenue)), Customer), Aggr(Rank(Sum({<Date={'>=$(LTM)'},Customer=>}Revenue)), Region, Customer))