i have a list box where i select 1 or more clients, and i have included in that list box the client 'TOTAL' where is the total amount of the clients. therefore the equation will be something like harold's sales / total sales = Market Share of Harold.
I have tried many things, I even make text objects for each part of the equation.
will give me the sum of the selected cllients, that is good in the text box.
The problem is that in the straight chart, at this moment shows: if one client is selected, at the end of the row where the Market Share should be is an ' - ' and at the superior row there's the value.
(Because i checked show expression total).
When i select more than one client, so i can see which client has bigger market share, is the same in every row at the last colum where the Market Share should be there's an ' - ', and at the top row of every selection is the Market Share of all the products selected over the TOTAL (Because i checked show expression total).