I have started playing with the new Reports tools. One thing I have found is that the Filtered By tool is limited in so far as the options available for interrogating the data.
In the use case I am attaching here, I am seeking a list of unique values (in this case an individual finishes code). I do not want every entity.
Is there a way to do this? If not, is it planned for?
I suppose other types of data modifications would be good too, groupings, totals, subtotals ... maybe even formulas ... dare to dream
p
actually ... it seems i was a little premature in my solution. Whilst the setting pointed out above does prevent duplicates from showing, it does not hide the whole row - only the instance.
You can see from the attached that the FinishCode duplicates are indeed hidden, but it is still showing every instance of the item type. Which is not what I was seeking.
What I am looking for is one row per instance of an item type. Is this possible?
I suppose that my original question still remains.
José
Nevermind. I found it.
Is case anyone is wondering, it is here.
Answer Verified By: Leonard Jones