Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good day,
Is there a way to only show the top Flavour Name whithout using a pivot table?
Please help
See attached
Thanks
try Rank() function.
Not sure how
rank([Flavour Name]) does not work
Wrong syntax maybe?
Three ways: First WAY: Double click on Sum(A1) to get sort indicator. Make them descending by double click on sort indicator Now go to presentation tab. find a checkbox: Max. No(1-100): specify 10 if you wanted to show top 10 Names Second WAY: First Go to Sort tab. Give your Sum(A1) descending order. Now go to presentation tab. find a checkbox: Max. No(1-100): specify 10 if you wanted to show top 10 Names Third WAY: using Rank Function as said by tres qv
for ascending order top rank --
try this
rank(fieldname)
for descending order top rank --
try this
rank(-1 * fieldname)
Sorry, I missed a part of your post. I guess it is better to use FirstSortedValue() for this. try like this:
FirstSortedValue( [Flavour Name] , Rank ( Sum(A1)) ) // assuming your ranking would be based on A1
FirstSortedValue( [Flavour Name] , Rank ( Sum(A1)) )
this does not work, but I also forgot to add, there is more then one flavour name, I only want the first of every name to display
i guess there is a gap between my understanding and your requirement. Can you please explain a bit more?
Better option would be if you can share app sample with requirement(expected result) described in it.
Thanks for the reply..
I attached a small model.
The customer name and the customer ID is repeating, I want to show only the first 'Jan'', the first Koos' first 'peet' etc. and their ID and not 4 jans and 4 peets, without changing the graph to a pivot table.
Thank you
PFA.
Is this what you want?