1 Reply Latest reply on Nov 28, 2016 12:34 PM by Sarah Ebreo

    Divide calculation depending on the filter selection

    Yuriy Ovchinnikov

      Hi all!

       

      Please help me to create a bar chart based on the filter selection.

       

      Say, the data as follows:

      Volume sold: 100

      Total cost a: 20

      Total cost b: 35

      Total cost c: 5

      for Year 1

       

      and different data for Year 2 and 3.

       

      Now I want to create a dashboard with a bar chart showing Cost per unit sold (Total cost a/b/c divided by Volume) for 3 years in a data set.

      So if I click at "Cost a" in the table 1 the graph should show 3 bars representing per unit cost of type a for year 1, 2 and 3.

      the same for b/c.

       

      Dunno how to create this(

       

      Thank you,