2 Replies Latest reply: Sep 19, 2013 4:19 AM by Jakub Szurogajlo RSS

    Pivot table expression for value of top week.

    Jakub Szurogajlo

      Hello,

       

      I am struggling with an expression for my pivot table.

       

      For example please have a look at pivot table:

      1.png

       

      I would like to write an expression which will show me the value of latest week in corresponding month.

       

      Co for example for car ID 910, I would see 80 in Aug, 0 (or null) in Jul, and 91 in September.

      Week column is for reference only and in final pivot it will be gone.

       

      I am attaching sample qvw document for your reference.

       

      BR,

      Kuba