4 Replies Latest reply on Sep 26, 2018 3:05 AM by Mark Gormley

    Item sale over percentage of total month sales visualization

    Mark Gormley

      Hi,

       

      I have attached a workbook. I currently have a text table view (Table Data Sheet) with the information I require which is total sales per month for an individual item and it also shows the percentage of sales for that item against the total number of overall sales for that month.

       

      I would like to visualize this into a dual axis chart but have so far been unable to achieve this. I cannot get the numbers in the text table (Table Data Sheet) to produce in the visualization (Graph Data Sheet), they are giving a different % of Total Sales. 

       

      Any assistance in this would be greatly appreciated.

       

      Thanks,

       

      Mark