7 Replies Latest reply: Nov 23, 2015 9:53 PM by Alexander Sehdeva RSS

    Short number



      Setting thousand/million/billion symbol does not work with straight table/pivot table charts. I am using a pivot chart to display numbers and would like to achieve the same short number format. E.g:


      123 -> 0.1K

      12345 -> 1.2K

      1234567 -> 1.2M

      12345678910 -> 1.2B


      Any smart way to achieve this?


      Thank you!