3 Replies Latest reply: Jul 3, 2013 5:05 AM by Mohit Sharma RSS

    Calculated dimension

    Paul Damen

      All,

       

      I have a straight table with 5 dimensions and 3 expressions. The data is taken from QVD's which are stored every week with new data and the document reads in the last 8 weeks off QVD's.

       

      Now the table I am making should only show data from the most recent QVD (QVD's are stored with week numbers so the name is WeekXData).

      I thought to add a calculated dimension: Week = vWeek. This does return the correct items but it adds a column with 0 and -1 for data that matches with this item and that doesn't.

       

      How can I get the table to only show the values from the latest week?

       

      Regards,

      Paul