7 Replies Latest reply: Nov 15, 2017 1:28 AM by P M RSS

    Values to repeat in a chart straight table

    nayan lalla

      Hi

       

      I want a value to be repeat in a column.  So in my table below, I want for the value for Min Month (ie Aug 16) which is 6 092 970 to be repeated in another column. (See 2nd table below for ideal answer).

       

      For simplicity, My dimension is Calendar Month and my Expression is Sum(Sales).

       

      Please note that Min Month is dynamic and not specifically relating to Aug 16

       

      Kind regards

      Nayan

       

       

       

      Calendar

      Month

      Sales
      Aug-166 092 970
      Sep-166 862 879
      Oct-166 530 097
      Nov-166 673 340
      Dec-166 219 913
      Jan-176 598 741
      Feb-176 280 318
      Mar-176 725 122
      Apr-176 395 875
      May-176 460 487
      Jun-176 616 062
      Jul-176 426 271
      Total77 882 076

       

      Ideal Answer

       

      Calendar MonthSalesLowest Month Sales
      Aug-166 092 9706 092 970
      Sep-166 862 8796 092 970
      Oct-166 530 0976 092 970
      Nov-166 673 3406 092 970
      Dec-166 219 9136 092 970
      Jan-176 598 7416 092 970
      Feb-176 280 3186 092 970
      Mar-176 725 1226 092 970
      Apr-176 395 8756 092 970
      May-176 460 4876 092 970
      Jun-176 616 0626 092 970
      Jul-176 426 2716 092 970
      Total77 882 076