12 Replies Latest reply on Mar 3, 2017 4:48 AM by Kashish Chauhan

    To create custom bins or buckets for Sales

    Jayshree Dawrewar

      Hi All,

       

      I want to create soemthing like shown below:

       

       

      This is based on some dummy data which I created randomly so please ignore the values. I want to create custom buckets for sales or revenue like 0-100K etc. I want to create these range dynamically. As of now I am creating them manually using calculated field.  Also if there is no measure value for that product in the cell it gives me blank space i tried replacing it with  lookup(sum(sales),0) but still its not showing me any 0 value for blank spaces as shown below:

       

       

      Does anyone have any solution for this?

       

       

      Regards,

      Jayshree