Source: cube
Daily average report
There is a cross tab report. In that report there are two columns current year, previuos year
and a row woking days
I need the average sales report till previous business day
(for eg: Today is wednesday, I need the data in the report up to Tuesday)
problem:
for 2007 working days are showing correct when I run the report
but for 2008 working days it is showing one day more
please share your ideas
Can't say what's going on without looking at your source and queries.
But if it is more by a day for 2008, then create a data item that adds 1 day when year = 2008.