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|
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 :
Crosstable (Month, Expression) LOAD Campus, [January customers],[February customers],[March customers]
DROP Table Table1;