Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi friends!
I am trying to show only 3 values per category:
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
It works!! I really apreciate it!
The idea was to use pivot table, thanks for your response
Hi Juan ,
Please close the thread as "Answered"
Thanks
Like this?
see the attached
Juan_Pedro86 Please close the thread by marking correct answer if you get what you are looking for