Thanks for the reply ! it's working for claim Id for well point - but when I duplicate it for kaiser (Tool tip : we should show kaiser and wellpoint claims id's separately) and add next to it isn't working.
Do need to add Claim number (kaiser) to the view ?
Final o/p: Need to have both claims (kaiser & wellpoint) for that TIN in the same view
Issuev1.twbx 4.6 MB
In that case you need to first pivot your data to get a single column of claims per TIN and then you can get them in a single row as I did per TIN. That's only what I can say about this situation. I know not that easy. There might be a way to show it in Tool tip too, but I am not able to get it at the moment.