Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How count disable dimensions

Hi everybody,

I have a pivot table with 10 dimensions, some of them disabled. The user select in a Inline Field what fields he wants to see, but it will never be all selected together

I need obtain always the total number of dimensions, 10 in this case.

I'm thinking in something like this:

GetObjectField(Dimensionality())

but Dimensionality only counts enabled dimensions.

Some Ideas?

Thank's.

Pol

3 Replies
chiru_thota
Specialist
Specialist

Hi Pol,

why can't you use your Inline field ( Dimension) and take count of the values in it.

So that you always you will get total no of dimensions irrespective of your selected/enabled dimensions.

thanks,

Chiru

Ex : Count({1}%PivotDimensions) 

maxgro
MVP
MVP

=GetSelectedCount(dimension)

or GetPossibleCount

Not applicable
Author

Thanks Chiranjeevi, but the Inline Filed contains only 3 values and every wich of them enable differents dimensions groups in the chart. (for example, 1 value in Inline Field, 3 dimensions on chart)

And perhaps in the future these groups change, so I need to do variable.

Regards,

Pol

PD: Sorry for my english