9 Replies Latest reply: Jun 15, 2016 9:21 AM by Filiberto Cacciari RSS

    Display only values of a field depending on the max existing value of another field

    Filiberto Cacciari

      Hi guys,

       

      what I would like to do is to create a pivot table.

      "Actual" values ( where we have value from jan to may) and "Budget" values ( where we have value from jan to Dec).

       

      I would like that the value of budget changes depending on the max existing value of month of "Actual".

       

       

      This is what i have now. Where values of "Actual" are from jan to may and values of "Budget" and "Y-1" are from jan to dec.

       

      What i would like is that budget and y-1 change their values depending on the max existing value of month that we have in "Actual".

       

      Is that possible in the expression of the table?

       

      This is what i would like to have (filtering on month):

       

      Is that clear enough?

       

      Here qvw and xls attached.

       

      Thanks.

       

      Filiberto

       

      stalwar1 swuehl gwassenaar cleveranjos