1 Reply Latest reply on Jun 12, 2018 2:45 AM by Mavis Liu

    Calculation Scatter

    Niranjan Banarjee

      Hi ,

       

      I want to build a scatter plot with linear trend line.

      X-axis and Y-Axis fields to be dynamic for example if I select 'YTD' in the parameter YTD- Sales should show and Y axis with YTD-(Price=Sales/Qty).

       

      I am able to achieve if i directly use Sales  and Price without considering the Parameter(YTD/Current Month)