0 Replies Latest reply: Nov 29, 2016 12:07 PM by Gourav Sikka RSS

    Help

    Gourav Sikka

      Dear Team,

       

      i stuck a requirement.For this i am sharing Excel.requirement is I want to make a pivot table.

      where dimension is article_code And Fiscal Month.

       

      But Expression be set on monthend. Suppose in Sep Month we Have 10 to 20 Dates..But i want t show only Monthend Date Regading Amount on Below Column Sep Month..Same As  next month.i want to show amount each month below only monthend value

      Header 1Header 2Header 3Header 4Header 5Header 6
      Article_CodeFiscal MonthAugSepOctNov
      10001100--
      10002-200-
      10003--300