get next dimension and total number of dimensions

[ali_hijazi]

Hello

I got a pivot table

is ther a way to find out how many dimensions are used?

if I'm at a specific dimension how do I get the next dimension?

Please advise

[chematos]

Do you know about Dimensionality() ? If you have QV 11 you must have this function

This function returns the number of the dimensionality you are in that moment and you can use functions with that, for example, max(Dimensionality()) and I supose you could use Dimensionality()+1 and things like that.

Try it and tell me.