4 Replies Latest reply on Apr 20, 2018 7:26 AM by Vedant Chaturvedi

    Calculate Bottom 20,30,50% records and use in Tables and Pie-chart

    Vedant Chaturvedi

      Hi All,

       

      I am stuck with calculating bottom % records from a data set and displaying them correctly in visualizations.

      The ask is to show bottom % records based on parameter and filter selections. I am able to calculate the bottom 20% and so on, but when visualizing, it shows incorrect data.

       

      The end goal is to show only bottom 20% dealers data in Tables, Pie-charts other visualizations using Segment and other factors.

       

      Attached workbook has what I have tried and a subset of data.

      Greatly appreciate any help I could get on this.

       

      Thanks!

      Vedant

       

      Current                                                                                               Expected