Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
I have a QS Table , i need the overall total amount , now it can display overall total on NO OF Staff 55 , but it cannot display eXP overall Total.
Can some one advise me.
Paul
May be use Aggr()
Sum(Aggr(
Sum({<year = {$(=Max(if(getselectedcount(year)=0,2015,year))-0)} , month = {"<=$(=Max({<year={$(=Max(if(getselectedcount(year)=0,2015,year)))}, sales = {'*'}>} month))"}, eXP={"eXP"} >} Amount*-1)/Rate/1000,
SOURCE))
My QVF file
May be use Aggr()
Sum(Aggr(
Sum({<year = {$(=Max(if(getselectedcount(year)=0,2015,year))-0)} , month = {"<=$(=Max({<year={$(=Max(if(getselectedcount(year)=0,2015,year)))}, sales = {'*'}>} month))"}, eXP={"eXP"} >} Amount*-1)/Rate/1000,
SOURCE))
Hi Paul
You can use the 'Total' keyword in a sum function to calculate the total across all dimensions for you eXP field
=Sum(Total eXP)
Hi sunny
Thank you very much
Paul
Hi sir
Can you help me by example ? I mean show me using the QVF file on how you make overall total display out .
Paul
Sent from my iPhone