Forum Discussion
Raul
Post Patron
Post PatronSubtotals for a previous week
Hello, I have two tables: Calendar table (with Data, Year, Qtr, Month and Week fields) and SalesTable (with de Sales field). I need the difference between sales of week previous year (column DIF) ...
v-yulgu-msft
Microsoft Employee
Microsoft Employee
RaulPost Patron
Post PatronHello v-yulgu-msft,
One more question about your post. If I want to filter for a year and return the difference with respect to the previous one, without showing the years in columns, how should it be done? Because now if you filter by the year field of the Calendar table, the DIF column returns the same value as the Year column.
Thanks a lot!