Skip to Content
0
May 29, 2018 at 12:56 PM

% share of total sales with bex structures and cells

102 Views Last edit Jun 03, 2018 at 05:18 AM 3 rev

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

capture-bex-c.png

capture-bex-a.png

capture-bex-b.png

Attachments

capture-bex-a.png (27.4 kB)
capture-bex-b.png (10.5 kB)
capture-bex-c.png (14.9 kB)