Max Date among WeekDays

[Anonymous]

Good day!

In attached model in pivot table "Max data" i show sum of quantity, used filter for 'Monday','Tuesday','Wednesday'.

I want to show the same, but with max date among 'Monday','Tuesday','Wednesday'.

Necessary result must be:

Point 1 :We: 23-09-2013    34

Point 2 :We: 23-09-2013    75

Thank you!

[Gysbert_Wassenaar · Accepted solution]

See attached qvw.

[Anonymous]

Thank you!