8 Replies Latest reply: Apr 20, 2015 11:30 AM by Aaron Morgan RSS

    Y axis scale format

    Emma Harrison


      I have a table with an expression for New Products as:

       

      (Sum(total_inv_line_value*invnewproduct) > 1000000,
      Money((Sum(total_inv_line_value*invnewproduct)/1000000), '£#.0m'),
      Money((Sum(total_inv_line_value*invnewproduct)/1000), '£##0K'))

      This provides me with the totals in thousands or millions.

       

      I would now like to create a bar chart and apply these rules to my Y axis scale, however

      I am not sure how to go about this.

       

      Currently my scale shows as

       

      0, 20, 40, 60 ...... ect.

       

      I need this to be in thousands or millions.

       

      Thank you in advance!