Only total in straight table in Column

[bsbernabe]

Hi There,

There's any possible way that i can view only the total of Straight table in a simple way?

this is what i have:

this is what output that i need.

Regards Bing

[dsharmaqv]

silmplly do HO+Branch

or

Column(1)+Column(2)

Show only total in straight table

[girirajsinh]

sum(Total HO)+sum(Total Branch)..that will display 29 in Top row and all rows.

If you want 29 should be displayed only in Header and not in rows, then I don't think that is possible or atleast I don't know.

[stabben23]

if( Dimensionality()=0,sum(Total Ho)+ sum(Total Branch),' ')

[bsbernabe]

Thanks Deepak Sharma, we are same expression

29 value is from the Total Mode to show the Total

that is why the total is 29

but if i didn't use the TOTAL Mode

This is the output below:

But what i need to show is Only Total like below screenshot.

[stabben23]

use Expression Total and Dimensionality() function

[ahaahaaha]

Hi Bing,

In expression you want to hide and for text color use expression (adapt to your need)

if(Dimensionality()=1,argb(0,0,0,0), black())

Regards

Andrey

[bsbernabe]

Hello There Thank you so much for all your respond i really appreciate,

so now i simplify my concern cause base on my original post its not possible.

Here my another concern, There's any way so get the total of Amount using expression not using Total Mode.

Regards,

Bing

[sunny_talwar]

Would you be able to share a sample where you doing this? Its difficult to see what you might be doing and it might be efficient if we see it for our-self

[bsbernabe]

Here my QVW for reference of my Concern

Regards,

Bing