Forum Discussion
Look up value based on (1) value between a range and (2) matching string
I'm trying to build a report that calculates sales commission based on seeveral tables. In my Report Matrix visual I have already gotten aggregate sales data from each salesperson, their resp...
PaulDBrown
Community Champion
Community ChampionCan you please share actual data as opposed to an image?
Hi PaulDBrown ,
You can try with the data in this file.
https://1drv.ms/x/s!Amug-t4AYqovg3BXu6LQrE4zeTPp?e=eVuAQ7
Let me know if you need more details. Thanks.