Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good afternoon,
One column of my straight table can contain duplicate rows. I have the table sorted on that row. Is it possible to have the value displayed for only the first record where each value occurs?
Thanks in advance.
Maybe you could add a row count and only include the data when row count =1
Randy
The distinct() function may be of use to you.
But you need to consider what end result you are hoping to achieve, if you wish to ignore duplicates on that column then you need to decide what to do with other columns you wish to display :
Also you may wish to do things in the load script or maybe in the dashboard.
As the old saying goes:
If you don't know where you are heading, then you'll end up where you are going
Best Regards, Bill
Try the ABOVE function
= IF(FieldName <> Above(FieldName), FieldName, '')
Thanks for all of the suggestions.
Dalton's, would your check be implemented within the Enable Conditional setting at the dimension, or somewhere else?
Thanks.
Sorry ... that's the actual Expression to use. Instead of just using the FieldName (such as Manager name) this expressions says "If the current value I would output doesn't equal the line above then go ahead and output their name, but if Bob Smith is already listed right above leave this cell blank.