3 Replies Latest reply on May 18, 2016 9:55 AM by Yuriy Fal

    Calculated Fields with Bins Intervals

    André Coelho

      Hi everyone!

       

      I'm trying to show in my workbook the % of sales for different [Obra] in different period of time (6 months). For each period of time I want to visualize one line that shows the goal for that period.

      Eg: For period 0 the goal is 40%; for period 6 the goal is 50%.

       

      I created a calculated field [Semester] and created Bins based on this field but it didn't work.

       

      The [Data] dimension goes over 2015 and 2016.

      [Vl Recbt] measure = total of sales/ month

       

      I've attached the workbook and the data source here.

       

      Could anyone help me?

       

      André