14 Replies Latest reply on Aug 14, 2019 9:33 AM by Ken Flerlage

    Using deviation from monthly avg sales to color code bubble chart

    Voltaire

      Hello everyone,

       

      I'm trying to compare monthly sales data for each client to the YTD monthly average, defined as SUM(Sales)/Number of months.

      I would like to subtract the monthly average to the monthly sales data and use the result to color code a bubble graph that shows monthly sales by client.

       

      So I need a constant figure for the avg monthly sales for each client, so that I can subtract it to the sales of the month I'm analyzing.

      As data sample we can use the Superstore data. I don't care what dimension the analysis is performed on, it could be customers or country or whatever.

       

      Thank you very much!