Forum Discussion
Count Values In Each Row (4 options) need it for stack bar chart
Anonymous
Open the query editor.
Select the 40 columns > right click > select unpivot
I tried to take your advice but it broke my query. I had to contact microsoft and they could not figure it out. Do you have another option that you know of to be able to look at the filters for each column and give me a total such as this? I have 40 columns
Anonymous
So sorry for that!
nothing in my mind now. I will thibk it over again and let you know if any solution comes to my mind.
Ok I appreciate it. I am going to look into how I can group the those columns together for now.
Anonymous
I was going through my old notifications and just noticed that I did not reply to you. I remember I read the message but apparently forgot to reply to you. Please accept my appology. Can you please sahre a sample file to work with and explain with examples the expected results. Thanks and have a great day!
Hey there, I am working on unpivioting the coumns. What is the next step from here?