Forum Discussion

Dhjlm's avatar
Dhjlm
Frequent Visitor
4 years ago

Need help with calculation

I have this problem giving me gray hair.

So I have customer no, sales, cost and cost of sales %.

The cost of sales % is correct for each customer no, but the total is wrong.

I would like it to be total sales divided with total cost, but instead it´s summarized.

Also the green visualizations is summarized, and choosing avarage or median also gives me the wrong result.

 

 

Need Help

4 Replies

    • Dhjlm's avatar
      Dhjlm
      Frequent Visitor
      4 years ago

      Sorry, that didn´t help

  • v-janeyg-msft's avatar
    v-janeyg-msft
    Community Support
    4 years ago

    Hi, Dhjlm 

     

    From your screenshot, we can't see how the 'cost of sales %' is calculated? So can you explain it? 
    If it's a measure, you may need to modify it by using sum(summarize()) function to make the total correct.

    And it's better to share some sample data and your desired result. So we can help you soon.

     

    Best Regards,
    Community Support Team _ Janey