Is there any way to know if a level of a pivot table is expanded or not?

[marcel_olmo]

I'm trying to figure ot if that is possible or not.

I have a pivot table like this one :

And I'd like to do something like this :

- If level3 is expanded Q3 would be Q1 + Q2.

-If level2 is expanded Q3 would be Q1 * Q2

-If level 1 is expanded Q3 would be (Q1 + Q2 ) / 2.

Is there a way to do that without using macros?

Many thanks in advance!!

[alexandros17]

Use function "Dimensionality()'

[marcel_olmo]

Thanks Alexandros for your answer,

but Dimensionality() only says in which level you are, not if the level is expanded or not.

[alexandros17 · Accepted solution]

In a pivot table Dimensionality says the expansion level in which you are, add an expression that shows dimensionality() and look at the result, I've often used it to change expression depending on the level of expansion ... let me know

[marcel_olmo]

Thanks alexandros, it solved what I want.

Regards, Marcel.