Displaying only first values of several dimensions in a Pivot Table

[herard_bertrand]

Hi,

I've a huge Pivot table with a lot of dimensions 

Is there a way to limit (showing X first values of at least 2 different dimension ?) 

Thanks

[herard_bertrand]

In fact I'm more or less looking for an equivalent of this QlikView parameter: 

[HirisH_V7]

Dimensionality:
If(Rowno()=1 and Dimensionality()=4 ,sum(Sales) <Your Exp>)

Dimensionality will be count of dimensions you have.

Using Rank:
If(Rank(sum(Amount))<=2,sum(Amount))

[herard_bertrand]

Thanks, that's a good start. Please note I'm trying to display the N available values for a Dimension and NOT the Top N values of a measure

[HirisH_V7]

You can use rank and acheive it. still if any, pl drop some sample data and desired output.

[marcus_sommer]

I suggest to re-think the task. Of course it's possible to count the number of available dimension-values for single fields as well as in their combination and/or to rank the expression-results even in regard to their position - dimensionality() and/or rowno() / columnno() - to restrict the view. But the efforts for it could become quite exhausting and also causing some performance decrease by larger datasets.

Therefore I could imagine that dividing the view into n appropriate designed charts - maybe secured with a condition on the object-visibility like: count(distinct Dim1&Dim2&Dim3&Dim4) < 1000 may be more expedient.