I have a 3 column datatable,
First column is the first of each month for a full year
Second Column is the name of the salespeople
third column is the Sales for the month for the salesperson
datatype of 3 columns are Date, String and Decimal
I want to have a Column chart with Y axis the $$ sold
X Axis (1) Months
and within the months i need the name of each sales person to by shown ( i have 5 salespeople)
What I am getting now, Is 60 columns, but no subgrouping.
Thanks
I was able to do it like that changing my datasource. I guess you have to crosstab the data before feeding it to the chart
Hello Fred,
I made small sample for you. Could you please take a look at the attached sample for more details and let me know if you have any questions.
Regards