2 Replies Latest reply: Feb 1, 2017 4:56 AM by Глеб Aitov RSS

    Custom range for Y-axis as maximum value of the measure + fix number

    Глеб Aitov

      Hi

       

      I use two dimensions on my chart:

      1. "Week of the Year"

      2. Year

       

      The result is as follows:

      Screenshot_29.jpg

       

      Now I want to create a custom range for the Y-axis, which is the maximum weekly sales out of the filtered range (in the example it is the week 16) plus fixed value.

       

      The formula I put is:

      Max([Sales])+{1.000.000}

       

      It does not work.

      Am i missing something?