DOUBLE EXPRESSION IN ONE ROW (FOR 2 COLUMNS)

[#1]

Hi Everybody,

I have a Pivot table and want to to create 2 expression for one row in 2 columns: These are my calculation:

=SUM({<GRP4_DESC_F={'M.O.D Directe Et Indirect'}>}BALANCE)

=SUM({<GRP4_DESC_F={'M.O.D Directe Et Indirect'}>}TONS)

As I said I want :

I have to do it by expression bcuz  some items from "GRP4_DESC_F" should be selected in certain order.

Any idea is appreciated.

Thanks,

Nima

Header 1	01/01/2011	01/01/2011
	BALANCE	TONS
'M.O.D Directe Et Indirect'	200000	450

[#2]

You are right, I tried almost every thing and could not find a solution. We are trying to switch our cognos reports to Qlick but unfortunately Qlick is not able to do every thing that is possible in cognos reporting tools.

Thanks,

Nima

[#3]

I'm still looking for a solution!

Any suggestion is appreciated ,

Thanks