How to get Overall Total in QS Table ?

[paulyeo11]

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

[paulyeo11]

My QVF file

[sunny_talwar · Accepted solution]

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))

[#4]

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)

[paulyeo11]

Hi sunny

Thank you very much

Paul

[paulyeo11]

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