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

    Displaying avg prices

      Hi,

       

      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

      avg(aggr(PY_PRICE,,MG_DESCRIPTION_MG_LEV1, MAT_MATERIAL_CODE)).

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

      Thank you