Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi:
I'm having problems trying to solve a problem similar to this. Giving this data:
YEAR-MONTH | DAY | QTY |
201501 | 10 | 100 |
201501 | 15 | 200 |
201501 | 20 | 300 |
201401 | 05 | 100 |
201401 | 15 | 200 |
201401 | 20 | 300 |
201401 | 30 | 400 |
201301 | 05 | 200 |
201301 | 10 | 150 |
201201 | 20 | 200 |
201201 | 22 | 250 |
Need to get this one if I select YEAR-MONTH = 201501
TOTAL PER DAY | TOTAL PER DAY | TOTAL DAY | TOTAL | TOTAL | AVG | DIF |
DAYS | YEAR-MONTH 201501 | YEAR-MONTH 201401 | YEAR-MONTH 201301 | 2 LAST YEARS | 2 LAST YEARS | YEAR 0 - AVG 2 YEARS |
05 | 0 | 100 | 200 | 300 | 150 | -150 |
10 | 100 | 0 | 150 | 250 | 125 | -25 |
15 | 200 | 200 | 0 | 400 | 200 | 0 |
20 | 300 | 300 | 200 | 800 | 400 | -100 |
22 | 0 | 0 | 250 | 250 | 125 | -125 |
30 | 0 | 400 | 0 | 400 | 200 | -200 |
Of course if I need to select other year-month previous years are recalculated using 2 previous years and same month.
I'm attaching excel file with data and desired output.
Any ideas?
Not sure if this is what you want (and there are certain things I don't understand such as Avg for last two years is based on last 3 year numbers divided by 2 and 2013 includes numbers from 2012, but assuming these were sample error, see if the attached helps)
Hi Sunny:
Some tips you gave me, but I have some problems trying to execute your qvw file and also reproducing into Sense.
This is what I got when trying to see your qvw file. A memory error.
And here is also an screenshot of Sense version using same load and formula values:
Im not getting same view like in QV.