Hi,
I've been trying to retrieve the records were the units values is in the top 3 , to do this I first grouped the data in this case by month
and sorted the groups descending, within I then used ;
to get top 3rd highest distinct value and {0} to get the value
I then wanted to use this a criteria for Table.SelectRows but can't figure out how to access it.
This is how i first trie, Just put '10' to get to work, but could not use the [TestA] vlaue,
I then tried to add the criter into the grouping ;
Any suggestion as to how to access a value created in the grouping, I have thought of add columns and using a let statement?
Update ; the got to a solution whihc is as follows ; within the group add column of for example 3rd highest unit , listrange ( {} , 2 ) , then again within the grouping
use table select rows
Updated file attached ; query ; result
RD
Bookmarks