Pivot table top 10 results

[#1]

Hello everyone,

So I am trying to show only the top 10 results on a pivot table.

The file I have in attachment has an example of my entire data and I want to show what is only painted in green. This corresponds to the top 10 descriptions.

I have already used the expression: aggr(if(rank(count(Column 1))Column 3),Column 3) wich is often used to achieve this kind of results, but I cannot have the top 10...

Am I doing something wrong?

Thank you in advance.

Best Regards!

[MK_QSL]

Can you also provide sample data please?

[aveeeeeee7en]

Try something like this:

Sum({$<Category= {"=Rank(Aggr(Sum(Value),Category))<= 10"}>} Value)

Regards

Aviral Nag

[#4]

Hi Ivo,

using your column numbers from that excel, think the below will work for you

=Sum({<[Column 3]={"=rank(sum([Column 4]))<= 10"}>}  [Column 4])

hope that helps

Joe

[#5]

So I am exploring the expressions you guys suggested.

Meanwhile here is the sample.

Note that if you change something and send the file back to me, I only have the personal edition, so I won't be able to open a file saved with the professional edition.

Thank you for the support.

[#6]

From that example then use

Sum({<Column_2={"=rank(sum(Column_3))<= 10"}>}  Column_3)

in your expression and move column 4 to a dimension

Joe

[#7]

With this expression I get a // Error in calculated dimension

[#8]

Also the expression // Error in calculated dimension, on column 2.

I can't move column 4 to dimension because I need an expression for the table to show results

[aveeeeeee7en]

Use this Expression:

Sum({$<Column_2 = {"=Rank(Aggr(Sum(Column_3),Column_2))<= 10"}>} Column_3)

Also, see the Attachement.

Hope, it helps you.

Regards

Aviral Nag

[#10]

Hi Ivo,

I just used your example and got no such error.

You will still have an expression so will get results, all I have done is move the expression for column 4 to a dimension and replaced with my new expression.

Please see below