I have a field called OrderID, if I select values in the order ID, I have Measure
GetFieldSelections(OrderID',',100000000)
Which Displays 234,456,876,897,985
Now I want to Separate these selections into two Parts, i.e. I selected 5 Order IDs so one part should have any 3 IDs, and the Other Part should have the remaining 2 IDs.
Two KPI, One KPI will display half of the selected IDs. Other KPIs should show the Remaining IDs...
If selection count is 100 cut it as 50 50 for each KPI,,
Something like this maybe: concat(distinct {<OrderID={"=Rank(OrderID)<=GetSelectedCount(OrderID)/2"}>} OrderID,',') And concat(distinct {<OrderID={"=Rank(OrderID)>GetSelectedCount(OrderID)/2"}>} OrderID,',')
