This content has been marked as final. Show 3 replies
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?