daily budget / target

[ilanbaruch]

Hi All,

i want to calculate daily score for sales rep  target and to present in a straight/pivot the accumulated performance value .

i.e : if sales rep have reached daily target by

day 1 :80% he gets 0.8 point

day 2 :90% 0.9 point

day 3: 100% 1 point

calculate total points for selected period (without day dimension in the table)

any ideas ?

Advanced thanks

[kfoudhaily]

can you provide details about your data model?

if possible please share a sample of your data.

regards,

[ilanbaruch]

date	target	sales	score
01/01/2018	100	90	0.9
02/01/2018	120	120	1
03/01/2018	150	140	0.93

total score is the requested calculation/expression