Expressions: Sales < $100, Sales >=$100 and < $200, Sales >= $200, Percentage of total sales
The request is to create a chart in the following format:
SalesmanA SalesmanB Total SalesmanA+B Total All Salesman
Total Sales < $100 10 5 15 120
Total Sales $100 - $200 5 7 12 100
Total Sales > $200 3 1 4 36
Total Sales 18 13 31 256
Percentage of Total Sales 7% 5% 12% 100%
I have set the presentation to Horizontal to have the dimensions displayed across the top of the chart. This issue I have with this is that I cannot seem to control just the column headers. For example I would like the column headings to be two lines but this changes all cells in the chart to two lines high. Is setting the presentation to Horizontal the best technique to accomplish this look?
The second question is what is the best technique to create total columns such as the total SalesmanA+B column if the values accross the top of the chart are dimensions?