Hello!
I am trying to summarize the information from different columns which have same descriptions.
ID A B C ....................................................... Z
1 Finished In_progress Finished Started
2 Started Started In_progress Started
3 In_progress Started Started Started
......
13452 Finished In_progress Finished ....................................... Finished
I want to have a table/Matriz that specifies how many IDs are in each step. And drill states for example if I click in A finished. That it shows me how many will be in the others.
I am trying to achieve somehing like this.
Started In_progress Finished
A 20 10 20
B 34 6 10
C 40 3 7
...........
Z 45 2 3
Is there any way without unpivotung the table and to do drill through. So, if I click on the 20. It will show me the states of the others.
Started In_progress Finished
A 20
B 4 6 10
C 10 3 7
...........
Z 15 2 3
The main goal is to have the same desctiption (Started, In_progress, finished) for all the states. (A-Z). The issue is that because they are in columns and not in row it is not easy to summarise it and by unpivot the table i lost the drill through and other characteristics of the table.
Which should be the best way to summarise it in this way without unpivot the table.
Thanks in advance.
Best.
