Hi Experts,
I have created a Bex structure and cashier name (See screen shot), for other cells I am able to use %A function in Bex but for sales I need to get % share of total sales for each cashier. I tried to use %CT, % RT but all of these are giving error messages. Do you know how to get results if I would like to get % share of each cashier in total sales (Cashier A/B/C share in total sales sum(Sales+Discount)
Let me know asap and if you need any further screen shots or inputs then let me know.
Regards,
Nitin