Dimensionality

[#1]

I want to insert subtotal for expressions. Since partial sums label does not allow custom label , I used dimensionality function for the expression. But I am having an issue where the text for the subtotal is showing as left aligned. I want this to be right aligned. I searched the function list but could not find it. Is there a way to set the alignment within expression ?

(Dimensionality()=1,'Subtotal ' & Group & '   ' & round(Sum( {<Source = {'CurrentSales'}>} Amount),1),Sum( {<Source = {'CurrentSales'}>} Amount))

[Gysbert_Wassenaar · Accepted solution]

You can set the alignment on the Presentation tab. You can set it for text values and number values separately. You seem to want to have both settings to Right.

[#3]

Didn't realize expressions are also listed there. Thanks!

[jolivares]

Hi Gysbert, may you see the example attached?  I was trying to acumulate values in the subtotal but I failed.

See please.

[Gysbert_Wassenaar]

See attached qvw.