You can accomplish this by making use of the PREVIOUS_VALUE function in Tableau. This function is a table calc so you need to make sure you set partitioning and addressing up properly, but I can get the desired result with this and a filter to make sure only the last iteration of the concatenation is showing.
Please see the attached workbook for an example.
All the best,
Concatenation.twbx.zip 9.3 KB
Thank you for your help, indeed it works perfectly!
However I have a small problem now, I am trying to export the data as crosstab.
My dataset is quite big and after all the aggregation/calculation I ended up with more than 20K rows and 1 column. Although I am using a 64-bit PC with 64GB of RAM, If I try to export or copy as crosstab, Tableau goes out of memory (More memory needed to generate the view. Please reduce the level of detail in the view or close some applications.)
I think this is due to the 'complex concatenation' calculation it has to do (if I remove it I can export the data with no problem), so, is there any other way to export the aggregated data as I see them in the worksheet?
Thank you in advance