Forum Discussion
Duplicate data visual rows
Hello,
I had data like below before pivot
| ID | Tag 1 | Tag 2 | Story Point |
| A | X | Y | 2 |
B | X | null | 3 |
| C | Y | Z | 4 |
After Pivot i am able to get the data like below
| ID | Tag | Story point | Tag story point |
A | X | 2 | 2 |
| A | Y | 0 | 2 |
B | X | 3 | 3 |
C | Y | 4 | 4 |
C | Z | 0 | 4 |
Issue here is in visual if iam selecting tag & tag story points. I can see 2 rows for the value X in Tag column
Please ignore the story points number. Forgot to change the number according to the above requirement.
Basically i dont want 2 values of X i want only 1 X with that total values of Tag story point. Under column (tags) also i am able to see 2 different X's like below
Can you please help with the above issue