Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi all,
how can i create a graph with 3 dimension?
i have:
2 salesman
2 years (2013,2012)
days (for month to date - 2013 and 2012)
and sales as expression
on OX have to be the days (1 2 3....24)
and i want to see the evolution for 4 lines (salesman 1 2013, salesman 1 2012,salesman 2 2013, salesman 2 2012)
in conclusion, i want to make comparatives between salesmen but with an eye also on last year the same period
thanks
cosmin
Create a calculated dimension with four values by concatenating Year and Salesman: =Year & '-' & Salesman. Use that calculated dimension instead in the chart.
Create a calculated dimension with four values by concatenating Year and Salesman: =Year & '-' & Salesman. Use that calculated dimension instead in the chart.
thanks, it works
so simple but so difficult if you are a beginner
many thanks again
cosmin