Partial Total

[#1]

Hello All,

I have this calculation in expression:

if(ColumnNo()=0, aggr(sum(T_JOUR_OUVRABLE),EQUIPE,RES_RCAT_DESC,MOIS_NAME),sum(T_EMPLOYEE))

My Partial total does not work and it does not return any thing.

Any idea?

Thanks,

Nima

[#2]

I have 2 different calculation in rows and columns. so I say if it's the total of the columns do the first calcul otherwise do the 2nd calcul.

........

[#3]

need some sample,qvw or excel.

[#4]

I posted the excel ....

Thanks

[#5]

the more clearly u express the problem the easier it is to get the solution.

if u don't, then the one who is answering guesses what is needed.

Pls post what o/p u need from this excel file......at least i don't understand what is needed.

may be only take few entries from the excel as i/p & the o/p for that i/p cud b posted.

thanks for understanding

regards

[#6]

Thanks for replying.

I replace the excel file with a new version.Please look at the red cells and tell me why I don't have the total on the them? as you see I have the partial total on all the lines and columns except on the grand total for this column.

Thanks,

Nima

[#7 · Accepted solution]

I got it. Thanks for all your replies.

if(ColumnNo()=0,sum(aggr(max(T_JOUR_OUVRABLE),EQUIPE,MOIS_NAME)),sum(T_EMPLOYEE))

[CELAMBARASAN]

Hi,

Aggr returns list or set of values its a best practice to use Aggr withing Sum function.