Tableau will collapse those duplicate records into a single row. Do you have any ID in your dataset uniquely identifying each row?
This could be a Row ID, Order ID, Order Date etc.
No I do not. I TRIED to concatenate order line number and Booking value (1.1_5000, 1.1_2000 etc) and compare 1 concatenated row with another.
If concatenated_field = concatenated_field then
keep only 1st booking value and make other NULL.
But I could not do this calculation
I have added a Row ID as a unique identifier. You can right click on the field name and uncheck 'Show Header' to hide the column. See attached workbook.
Hope this helps.
Unique Row Values_OO_v10.0.twbx 20.1 KB
Thank you so much for the calculated formula.. But..
My data-source does not have any unique Row_ID. Can I generate one? (Perhaps using Index()?)
I'm not sure if the index() will also work in the background or only when used on the sheet.
I wanted to consult before applying the formula.
Index() is a table calculation and therefore cannot be mixed with LOD.
You can still use Index and Lookup to get the correct result. However, bear in mind that you are limited in what you can do with the results. For example, you cannot just pluck the result and use it in every chart or calculation, without having all the fields used in generating the calculation in the view. See attached workbook.
Step 1: Go to Analysis and uncheck 'Aggregate Measures'.
Unique Row Values_OO_v10.0.twbx 32.2 KB
The second solution worked like a charm. Thank you so much. Now I can use this calculated field to create my other calculations such as discount and other stuff...
BIG Relief. BIG Thanking!