Forum Discussion

Solution Specialist

4 years ago

hi

hi, I attached an excel file where I need a sales representative to target each month need a measure Marketing Reprsentative Name Item name Month Target (in % percentage) A pen ...

Need Help

abc_777

Solution Specialist

4 years ago

still waiting if anyone has any solution for target Vs actual sale = achievement

abc_777

Solution Specialist

4 years ago

I updated my query for better understanding.

abc_777
Solution Specialist
4 years ago
how can i do this measure

if
jhon then (total sale * 0.1)
if
Dan then (total sale * 1.1)
if
Bill then (total sale * 0.5)

also i want to put marketing person (Jhon, Dan, Bill) in slicer selection