Exclude dimension in straight table total row

[sifatnabil]

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?

[sunny_talwar · Accepted solution]

May be try this

If(Dimensionality() = 0, Aggr(Rank(Sum({<Date={'>=$(LTM)'},Customer=>}Revenue)), Customer), Aggr(Rank(Sum({<Date={'>=$(LTM)'},Customer=>}Revenue)), Region, Customer))