Hi,
I suspect this is easy, but I'm struggling to find the solution so reaching out for some help.
I have a Column replicator which works fine. I would like to modify this replicator so that it creates columns based on the highest 10 values but sorted in ascending order.
Using the "Limit=" filter alongside the sort order for the field will list the columns in the wrong order.
Cheers for any help,
Managed to get a work-around for this using "SQL= "
In a cell (eg A2) is "SQL=Select t.Field From ( Select distinct TOP(10) Field From Table Order by Field Desc) t Order by Field
This is referenced by the Column replicator :
=NL("Columns",$A$2,"Date","DataSource=","DataSource")
Hope this helps someone,
Cheers
Sorry, the replicator should read :
=NL("Columns",$A$2,"Field","DataSource=","DataSource")
You can review the "Sort by Sum" article within these message boards to accomplish what you want to do without using SQL=