Measuring base on calculated benchmark

[Alsayyed]

I calculate a benchmark table (calculated colomn) and i want to meage my sales man and products based on this benchmark

[Alsayyed]

I have all sales per product and sales man, and i had calculated the % from totals and i want to meager the sales man efficiency based on the calculated benchmark

[v-yulgu-msft]

Hi @Alsayyed,

Based on current description, it's not very clear about your requirment. I guess you have created a calculated table named benchmark, now you want to make some calculation based on this table, right? However, what is your source table and how did you create the benchmark table? And what did you mean meager sales man and products?

Please share some sample data and expected result so that I can reproduce your scenario. Please provide more detailed information about your actual requirement.

Thanks,
Yuliana Gu