Pivot table: fill only based on a specific field's value

[#1]

Hi,

I have a table containing data to compare the values of the last three weeks. For this, I added a field called EXTRACT_WEEKNAME to the existing data.

So I have something like

ID     Value     EXTRACT_WEEKNAME

1      500€      2013/44

1      650€      2013/45

2      300€      2013/44

2      250€      2013/45

How can I set up a pivot table that only shows the lastest entries (meaning latest EXTRACT_WEEKNAME)?

Thanks,.

[#2]

Anyone who can help, please 🙂 ?

[Gysbert_Wassenaar]

See attached qvw