Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello there,
can anybody tell me why
=sum (
sum( Qty ) - before ( sum( Qty )))
doesnt work in dimenssions / pivot table?
How to change this?
thank you!
Marta
Marta,Try this: Sum(Qty) - Before(Sum(Qty)), you can't have in the same expression: Sum(Sum()). Maybe: Sum(Aggr(Sum(), .... ))Gabriel