graph with 3 dimensions

[#1]

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

[Gysbert_Wassenaar · Accepted solution]

Create a calculated dimension with four values by concatenating Year and Salesman: =Year & '-' & Salesman. Use that calculated dimension instead in the chart.

[#3]

thanks, it works

so simple but so difficult if you are a beginner

many thanks again

cosmin