Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try this:
=Sum(Aggr(Sum(Distinct {<DIVISIONCODE = {'HO'}>} RangeSum(NetWorkDays(SUSDATEFR1,SUSDATETO1), NetWorkDays(SUSDATEFR2,SUSDATETO2))), BADGENO,SUSDATEFR1, SUSDATEFR2, SUSDATETO1, SUSDATETO2))
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.
if( Dimensionality()=0,sum(Total Ho)+ sum(Total Branch),' ')
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.
use Expression Total and Dimensionality() function
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
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
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
Here my QVW for reference of my Concern
Regards,
Bing