Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Row context by agent and by customers

Hi everyone. I have an Issue: I need to make a distribution of Sales Agent Salaries by Customer. And the distribution it will depend the amount of sales of each customer of each agent from the tota...
Need Help
  • v-xiaosun-msft's avatar
    v-xiaosun-msft
    3 years ago

    Hi Anonymous ,

     

    Thanks for your reply. That is because they are calculated by different values such as "Total Quantity ALL" and "Total Salaries".

    I marked them in the screenshot below.

    To solve this, you just need to add a slicer. Put "AgentKey" to the slicer and you will get the expected result.

    I attach my sample below for your reference.

     

    Best Regards,
    Community Support Team _ xiaosun

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-xiaosun-msft's avatar
v-xiaosun-msft
Icon for Community Support rankCommunity Support
3 years ago

Hi Anonymous ,

 

Thanks for your reply. That is because they are calculated by different values such as "Total Quantity ALL" and "Total Salaries".

I marked them in the screenshot below.

To solve this, you just need to add a slicer. Put "AgentKey" to the slicer and you will get the expected result.

I attach my sample below for your reference.

 

Best Regards,
Community Support Team _ xiaosun

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Sorry for the delay, I was a little bit busy.

 

The problem is that I add the Agent slicer, but brokes me some other measures that I have in the same report that are calculated by customer.

 

Also, I have a lot of measures that are being summed by customer, but this measure that is calculated by Agent, is not summing the value of the customer only, it is summing the entire value of the agent.