I have 3 fields, Date, Country and TotalPageViews.
The total page views for the same 5 countries are recorded for each day. So, each day has 5 countries, each with 1 page view value.
I would like to create a table that in column1 has date, column 2 has country, column 3 will have the total page views, but column 4 gives the number of new page views for each country for each day i.e. the difference bewteen the total page views on a day and the total page views on the previous day.