Forum Discussion
100 % Stacked bar chart
Hi Anonymous ,
Do you have any specific column that you use as ID? If yes I would split your model in two table one with all the Portfolio information that you will not unpivot and delete all the columns A to I and a second table that would be the ID column and the unpivot of the A to I columns then linked both tables by the ID column.
To calculate the status you would use the 2nd table and for the rest of the setup the other table.
Hi MFelix ,
Sorry for not providing the entire data set.
For example I have a Portfolio column here, i want to use this as a filter.
Also, each record represents an application. Unpivoting increases the number of these records and I get a wrong count.
Is there any other way of getting this done?
Kind Regards,
Adarsh
Hi Anonymous ,
Do you have any specific column that you use as ID? If yes I would split your model in two table one with all the Portfolio information that you will not unpivot and delete all the columns A to I and a second table that would be the ID column and the unpivot of the A to I columns then linked both tables by the ID column.
To calculate the status you would use the 2nd table and for the rest of the setup the other table.
Thanks a lot for this. Now i can get the exact visual I wanted.