Quote:
Originally Posted by ArviLaanemets
As it looks like you have defined a Table, and assuming for a location you have not more than 1 row on same day (on fly):
Code:
=SUMIFS([Ext. Price],[Name],[@Name],[day week],[@[day week]],[week],[@week],[year],[@year]-1)
|
Hi ArviLaanemets,
the tip you gave me was FANTASTIC, but now i have another issue
with that table i created 3 pivots - one for week sales, one for monthly sales and one for year to date sales.
the question is:
do you know a way to have the monthly and year to date to display like for like numbers?
Again thanks very much for your help.
06-09-2018, 07:35 PM
Similar Threads
Table with values from several locations and years - need to find comp values
Windows 10 
Office 2016
Threaded Mode