Visokio website     Downloads     Video tutorials     KnowledgeBase  
Showing percentage in bar chart view - Visokio Forums
Showing percentage in bar chart view
  • xuanzheng November 18, 2010 11:58AM
    Hi,
    I want to use the bar chart to show the percentage sales of each individual brand ( relative to total) over the selected period.
    is it possible to show the percentage in this case ?
    Many thanks
    Xuan
  • 3 Comments
  •     edward November 18, 2010 1:27PM
    You can add a formula field calculating the percentage of each record to the total using the SUBSET_SUM function, then set the bar view to show this field as its value. Please see attached for an example.

    For simple percentage representations, better to use the Pie view, where % is calculated/displayed automatically.
  • xuanzheng November 18, 2010 2:29PM
    Hi Edward,
    Thanks for the solution.
    My problem is that the sales of each individual brand are on the monthly basis,I want to get the % of contribution over the selected month. I guess in order to do this , i have to calculate cumulative sales of each brand over the month, then divide by the cumulative total sales. is it possible to do this on omniscope
    Thanks,
    Xuan
  •     edward November 18, 2010 2:55PM
    This can be done with the SUBSET function by defining a subset called Month. Please see the attached.

Welcome!

It looks like you're new here. If you want to get involved, click one of these buttons!

Sign In Apply for Membership