Another expression in case of drill down level

[#1]

I want to report a different expression in the same column with drill down fucntionality.

For ex. Product drill down contains :

- productgroup

- sub-productgroup

- product = SKU

So for the productgroup and sub-productgroup and want to report the WEIGHT. When I'm going to the product SKU level , I want to report in the same column PIECES !

Can anyone give me a hint.

THX
Marc Catteeuw

Inside Comlmunications

www.insidecomm.com

[sparur]

Hello marc.

you can create if statement in your expression:

IF(getcurrentfield( myGroup ) = 'productgroup', sum(WEIGHT), sum(PIECES))

[#3]

OK Thx. Is working perfectly.

Another additional question /

What can I do if I'm not working with drill down function, but with pivot table with different dimensions. When I'm on the dimension "Product - SKU" I should also report pieces. The other dimensions must be reported in weight.

Marc

[sparur]

You can use

dimensionality ( )

and

secondarydimensionality ( )

functions for create IF statement:

for example:

if (dimensionality() = 3, sum(PIECES), sum(Weighr))

but I would prefer create 2 different pivot tables with different expressions.

[#5]

OK THX A LOT.

CLOSED.

Marc