Pivot Table. Top3 Values

[#1]

Hi friends!

I am trying to show only 3 values per category:

• Facturas
• Recuperado

So what I tried was this: =if(aggr(rank(SUM(Datos)),[Origen Factura])<=3,[Origen Factura],Null()) 

But It didn´t work, it only shoy me the 3 values per one category ( facturas) due to this category is much higher/bigger  than the other  one but what I want is 3 values per category not 3 in total.

Many thanks

[#2]

It works!! I really apreciate it!

[#3]

The idea was to use pivot table, thanks for your response

[#4]

Hi Juan ,

Please close the thread as "Answered"

Thanks

[Kushal_Chawda]

Like this?

see the attached

[Kushal_Chawda]

Juan_Pedro86 Please close the thread by marking correct answer if you get what you are looking for