LOAD * INLINE [
Country, Salesman, Year, Sales
Australia, Rolf Wesenlund, 2005, 1030
Australia, Rolf Wesenlund, 2006, 1210
Belgium, Charles Ingvar Jonsson, 2006, 1210
Belgium, Charles Ingvar Jonsson, 2008, 3159
Belgium, Charles Ingvar Jonsson, 2009, 3690
Belgium, John Cleaves, 2008, 2550
Belgium, Tony Cedholt, 2008, 2500
Belgium, Tony Cedholt, 2009, 4249
load * inline [
Sales (In u r expression)
If(Dimensionality()=1,'Total ' & Country & ' ' & num(sum(Sales),'#,##0'),num(sum(Sales),'#,##0'))
Hope this helps you
Sub Total.qvf 176.0 K
To explain what dimensionlity() is; , to put it in simple words, It's the 'position' of our dimensions.
In the table that Devarasu shared (gret work by the way), he works with 3 dimensions:
1) Coutry => Dimensionality()=1
2) SalesMan => Dimensionality()=2
3) Year => Dimensionality()=3
As for the total (first row); It's Dimensionality()=0.
With knowing that, we can take the customization of our tables to a whole new level !
Hope that was clear enough.