14 Replies Latest reply: Jan 18, 2017 10:45 PM by bing bernabe

Only total in straight table in Column

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

• Re: Only total in straight table in Column

silmplly do HO+Branch

or

Column(1)+Column(2)

Show only total in straight table

• Re: Only total in straight table in Column

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.

• Re: Only total in straight table in Column

use Expression Total and Dimensionality() function

• Re: Only total in straight table in Column

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.

• Re: Only total in straight table in Column

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

• Re: Only total in straight table in Column

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

• Re: Only total in straight table in Column

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

• Re: Only total in straight table in Column

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

• Re: Only total in straight table in Column

Here my QVW for reference of my Concern

Regards,

Bing

• Re: Only total in straight table in Column

Which fields should be in dimensions and expressions of the table?

Regards,

Andrey

• Re: Only total in straight table in Column

Is this what you want?

Used this expression:

=If(Dimensionality() = 0, Sum(WRKSum), ' ')

• Re: Only total in straight table in Column

Hello Sunny Thank you for your support, base on your expression what i need is the Total of Rows i do something but i know its not proper or correct cause I'm using Distinct to get the Total Row can you correct me

=Sum( aggr( sUM(Distinct If(DIVISIONCODE= 'HO', NetWorkDays(SUSDATEFR1,SUSDATETO1))),BADGENO,PENALTY) ) +

Sum( aggr( sUM(Distinct If(DIVISIONCODE= 'HO', NetWorkDays(SUSDATEFR2,SUSDATETO2))),BADGENO,PENALTY) )

Note Try to Use sample

0369 i got the correct Total but here at

0811 i got wrong Total

Best Regards,

Bing

• Re: Only total in straight table in Column

Try this:

=Sum(Aggr(Sum(Distinct {<DIVISIONCODE = {'HO'}>} RangeSum(NetWorkDays(SUSDATEFR1,SUSDATETO1), NetWorkDays(SUSDATEFR2,SUSDATETO2))), BADGENO,SUSDATEFR1, SUSDATEFR2, SUSDATETO1, SUSDATETO2))

• Re: Only total in straight table in Column

Yes. Thank you Sunny I got it you such a great..