5 Replies Latest reply: Jun 4, 2013 10:46 AM by Mark Sheraton RSS

    Column reference calculation in pivot tables as Excel, help!

    Zeljko Mijailovic

      Hi!


      Can someone help me with the following problem.
      I have a pivot table where the formula needs to be adjusted.
      The formula referenced on calculated columns.
      How do I get the formula correctly adjusted so that the result corresponds to the attached Excel (column Set and the Dayend - correct formula).

      Furthermore, the calculation for the column Dayend should be stored when I select the month 2 in the Listbox.

      For example when I select the second month then the Dayend is to be taken from the first month -> last day from first month

      (Dayend before = -2443 for the Day 31.01.2012).

      Thanks for your help.

       

      Screenshot from Excel:

      screenshot.png