Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello experts i have a modelling question or creating a chart question to help me visualize my better in a better way.
This is how the table looks now.
Header 1 | Header 2 | Header 3 | Header 4 |
---|---|---|---|
Campus | January customers | February customers | March customers |
East | 8 | 12 | 34 |
South | 4 | 3 | 6 |
End product:
I want to create a line chart by month, by campus to show a trending line for the months. That means i want to have two lines that are connected, one will show the East zone and the other one will show a south zone.
Thank you experts for all the help.
You can use CrossTable prefix with :
New_table:
Crosstable (Month, Expression) LOAD Campus, [January customers],[February customers],[March customers]
resident Table1;
DROP Table Table1;
Like this may be -
yes Thats the way i want it to look like.
Have you got what you needed in the file attached?