How to hide dimension vallues and just show the Totals Row in Straight Table?

[jblomqvist]

Hi all,

I have the following straight table:

How can I hide the Dimension values so it only shows Total Sales and the total value. I.e. Hide the text and values you see in white?

Dimension = DivisionName

Expression: Sum(LineSalesAmount)

Anyone know how?

[Anil_Babu_Samineni]

If you really want to hide dim then why do you creating the Straight Table.

You can create script like Sum(LineSalesAmount) as Sales and then take sales in your object.

[vishsaggi]

As Anil said you can use that in the script. However, if you really want to hide the dim's then use this:

Dim: = 'Totals'

Expr: = Sum(Total LineSalesAmount)

Then check radio buttion No Totals in the expression tab.

[sunny_talwar]

vishsaggi‌ -

Although adding TOTAL won't do any harm, but the Sum(LineSalesAmount) should work here as well.

Another option is

Dimension:

DivisionName

Expression:

=If(Dimensionality() = 0, Sum(LineSalesAmount))

[vishsaggi]

True. Thanks sunny for that. Got it.