Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Guys,
Please help me on solving and having the exact report below:
Say that these my data
ITEM INQUIRY
MONTH YEAR | QTY |
---|---|
DEC-2011 | 56 |
JAN-2012 | 60 |
FEB-2012 | 30 |
BACKDATE QTY
MONTH YEAR | QTY |
---|---|
DEC-2011 | 6 |
JAN-2012 | 9 |
FEB-2012 | 15 |
THIS THE FORMAT/FORMULA EACH MONTH:
JAN-2012 | FEB-2012 | MAR-2012 | |
---|---|---|---|
BEGINNING | Dec 2011 item inquiry + Dec 2011 back date | Jan 2012 item inquiry + Jan 2012 back date | Feb 2012 item inquiry + Feb 2012 back date |
RESULT:
JAN-2012 | FEB-2012 | MAR-2012 | |
---|---|---|---|
BEGINNING | 62 | 69 | 45 |
I really don't know how to do that in set analysis or what should be the good thing to do.
Your help and suggestions are much appreciated.
Thanks,
Bill
Dear Bill,
You need to do some changes in data model.
You need to link both the tables and then this will be easier for you.
The script will look something like this.
ITEM_INQUIRY:
Load Month_Year,Qty as Item_Inquiry_Qty From ITEM_INQUIRY;
BACKDATE:
Load Month_Year,Qty as BACKDATE_Qty From BACKDATE;
Here both the tables will link by Month_Year.
Now all you need to do is create a chart with expression as
sum(Item_Inquiry_Qty) + Sum( BACKDATE_Qty)
Hope this is clear.
Regards,
Kaushik Solanki
Hi,
Please find the attached sample file for solution.
change the date format in the initial of script and then it will be easy to manupulate data in chart.
HTH
Sushil