Wondering if there is a way to do this without modifying the original data source.
I am querying a DB into a pivot and have 2 years of data, so field 1 is date, field 2 is a number.
I want to compare the # for the same week # YoY.
So week 13 in 2010 vs week 13 in 2011 as I cant compare week of march 27- April 2nd YoY as it did not exist in 2010..
Also Id like to be able to compare day of week YoY.
So id like to be able to compare say Monday the 28th of March, 2011 number not to the 28th of march in 2010 but to the corresponding monday in the same week, i.e. the 29th
is there any simple way of doing this in a pivot without modifying the source?
thx
I am querying a DB into a pivot and have 2 years of data, so field 1 is date, field 2 is a number.
I want to compare the # for the same week # YoY.
So week 13 in 2010 vs week 13 in 2011 as I cant compare week of march 27- April 2nd YoY as it did not exist in 2010..
Also Id like to be able to compare day of week YoY.
So id like to be able to compare say Monday the 28th of March, 2011 number not to the 28th of march in 2010 but to the corresponding monday in the same week, i.e. the 29th
is there any simple way of doing this in a pivot without modifying the source?
thx