15 Replies Latest reply: Nov 12, 2013 11:41 AM by Carlos Reyes RSS

    Displaying avg prices



      I have a pivot table in which I have to display the PY Prices for each material and month and the PY Price at material level without considering the month. (see the attachment for a good understanding).

      The problem is when I calculate the PY Price for each material, it compares only in one cell, but I'd like to repeat the same value for all months.

      My formula is


      How to modify it in order to repeat the value in all the other cells?

      Thank you