SUM OF ROWS INSTEAD OF EXPRESSION TOTAL IN PIVOT TABLE

[#1]

Ciao to everybody,

I have a problem. I have a pivot table with some dimensions and some expressions.

The dimension [Pos Tg]=valuelist('01',....,'15','Tot').

Expressions Reale and Ordini are two sums.

Expression + is equal to Ordini-Reale only if Ordini-Reale>0 (that is if(column(2)-column(1)>0,column(2)-column(1)))

Expression - is equal to Ordini-Reale only if Ordini-Reale<0 (that is if(column(2)-column(1)<0,column(2)-column(1)))

On the total line a would like to have expressions + and -as the sums of the rows instead of expression total.

So on the total row for + and - expressions I would like to have the following situation:

Could someone help me??? I've tried all possible aggregation functions available!!!

Many thanks to everybody.

[#2]

Hi Elena?

Might be my age but - beside the repeated listing of Offer and Codice in table 2 - I do not see a difference between your 2 tables?

Regards

Juerg

[#3]

Dear Juerg,

the differences between the two tables are on the totals on the last two lines (in the second one I write myself the numbers I would like to have...)

I hope now my problem is clearer.

[#4]

Hi Elena

OK, saw it now. Sorry but am not aware that you can have a different formula in the total than in the details or that we have a queriable flag when being in the total row.

Regards

Juerg

P.S. where do we go for vacation now - beach or mountains?

[#5]

Thanks for your answer.

Always mountains: the beautiful Dolomites!