8 Replies Latest reply on Feb 16, 2018 9:11 AM by dinesh punnam

    Ranked bar chart - only take into account what is in the view

    Nathan Haines

      Hi All,

       

      I am having a problem with a bar chart that i have created. I would like the bar chart to only take into account the number or vehicle makes (and the units sold of these makes) when changing the number of makes to show
      i.e. this is the top 10 (as you can see all the dark blue bars add up to much less that 100% as there are actually 38 makes that sold):

       

       

      and this is if you reduce it to just 1 (as the first two are tied for number 1):

       

       

      Both dark blue bars should now show 50% as they are the only 2 makes showing (the same needs to happen to the light blue bars also, but the dark blue bars are an easier example).

       

      If you need any more information, please let me know and i will do my best to provide this - I have tried this a couple of ways incl. table calculations but can't seem to get it to do what i need.

       

      Thanks in advance for all your help,

       

      Nathan Haines