Hi everyone,
I have a table and the columns in questions are calculated columns:
1) Students cohort a, 2) Students cohort b, 3) Students cohort c 4) Students cohort d
I want to create a bar graph that has these 4 columns as x axis headings, after a little searching on this forum I found that I have to create the calculated columns in query and then unpivot.
I have done all the steps, however even after I unpivot, I still cannot get the column heading to be on the same x axis. I would like a little clarification on the steps if anyone has any idea,
1. I have created the calculated columns in query
2. I select the columns and then unpivot the columns
3. I then have an attribute column which has the column headings in as rows, however after this step I am then lost as the attribute column doesnt show up when I close and apply and I am in report view, so I am not sure as to how to get the visual to work?
Thank you in advance for the help
P x
