Forum Discussion
TBenders
Helper II
Helper IICombining rows based on unique id, and combining information
Hi, This is my first post on this forum, but I've been 'lurking' around for a while, learning as I go. Hopefully one of you BI-wizards can help me out with my particular case for which I couldn't...
Sorry, forgot to mention that you need to turn the aggregation off: last step: Advanced Opions: Don't aggregate bofore hitting the last OK.
ImkeF
Community Champion
Community ChampionSorry, but I cannot find any clarification in you latest post.
Please keep your samples to the first 3 "Legajo"s: 154, 219 and 305:
- What do they contain? (You can use the formula I've suggested, but don't have to. Otherwise just paste the raw data)
- How do you want to visualize them?
The source of your data is irrelevant at this stage.
The error occurs because the titles "Estilo Personal" and "Áreas de Mejora" appears several times. I show you the difference between the error and the rows OK:
Before pivot:
Error example: 503
Example OK: 450
As you can see the difference are the duplicates of the titles. But as i said if i eliminate them it will eliminate all the info of the column "Value"
Thanks