Delta with three dimensions in table?

[#1]

Hi,

I have a problem to do a delta with three dimensions. With two dimensions, using Secondary Dimensionality is fine, but with three dimensions doesn't work.

Can someone help me?

Follow attached an example.

Thanks!

[swuehl]

Guilherme, could you check your attachment? Can't see neither the data  nor the table chart.

[#3]

Sorry swuehl. I think it's easier an excel file, I don't know why the qv file doesn't works.

[swuehl]

How does your expression look like?

[#5]

if(SecondaryDimensionality()=0, last(sum(Sales))-first(sum(Sales)), sum(Sales))

[swuehl · Accepted solution]

You probably need to test SecondaryDimensionality() against 1, not 0.

Just input an expression

=SecondaryDimensionality()

and see what is returned at that column.

[#7]

You're right swuehl, thanks!