Forum Discussion
Category Assignment with Multiple Different Category Values within Each Row
Hi tamerj1 I remember you helped me previously, do you know if there is a fix to this as I need to know quite soon? Thanks
- tamerj1
Community Champion
Hi Anonymous
Please provide some sample dummy data just with required amount of columns and present your expected outcome based on the same sample of input data.Hi tamerj1 thank you and please find a link to an example file: https://ufile.io/03vwaf4f
As you will see I have three different categories - Authorised, Rejected and Pending - of which for some rows, total demand is populated by more than one of the categories. However, I still want to be able to filter the total demand by each particular category but can't find a way to assign a category breakdown and use this to create a slicer. I would like to work with any other filters that are applied, and for it not just to be linked to the Total column as I might creat sub demands in my data.
I hope this helps and let me know if something isn't clear, appreciate the help.- tamerj1
Anonymous
Attached sample file contains 3 potential solutions.
One of them which I do recommend includes unpivotting the three columns.The thing which is not clear is how to deal incase there is supply but no demand. This is why you will see that the three solutions behaves differently.
