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

    Y axis scale format

      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!