Hello guys,
in my dataset I have Deals with different classes. I want to merge the classes as strings and only show the merged line. Therefore I have written a calculated field, wich adds the classes part by part:
Shown in a table it looks like this:
To only show the fully concatenated classes I want to filter those and only show the last row:
Unfortunately when I filter like that the concatenation is broken. I guess because it filters first and then the calculated field "Dealdata Concat" is processed. I tried to fix this issue by using the FIXED-method but it is not allowed to use with the PREVIOUS_VALUE-method,
Thank you very much for your help! 😊
Create the following calc:
LAST()=0
Place onto Filters Card by itself, then right-click, then Edit Table Calc. In the dialog box set to use Specific Dimensions. Set the Restart to Dealname. Click Apply. Then, right-click the calc in the Filters Card again and set to TRUE. Best, Don
