12 Replies Latest reply: Dec 1, 2016 12:27 AM by Lech Miszkiewicz RSS

    Replace row dimension value using set analysis

    Jon Jerome Cariaso

      Hi! I would like to ask if there's a way to change the value of a certain row dimension in a single pivot table using conditional calculations  (Set Analysis)?

       

      Source Table:

      Capture1.PNG

      Desired Result:

      Capture.PNG

       

      Thanks in advance