Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Friends,
i am facing one problem,i needed help,i attached the test data,if user selected Year=2014 and Month='Jan',then Max Date of
Jan-2014 is 31-01-2014.i want to display Vensor_Prise value where Transaction_Period<='31-01-2014', and MAX(Transaction_Period) based on vendor_Name and Iten_ID.
based on above condition i want to calculate vendor price value...
Thanks fro your help.
Can you check the Required Result you have mentioned in excel file is right or not?
Your required result is not please provide more info also check field names.
Regards
New Update please check now but it is in the backend
Try to load your table like
Temp:
LOAD
[Vendor Name],
ITEM_ID,
EFF_STATUS,
Transaction_Period,
VENDOR_PRICE
FROM
(biff, embedded labels, table is [Test Data$]);
Load
[Vendor Name],
MaxString(Transaction_Period) as Maxdate,
Sum(VENDOR_PRICE) as Sumven
Resident Temp
Group By [Vendor Name];
Let me know if it works for you in the backend and i try to work on the front end.
Thansk & Regards
Hi Anand,
Thanks for your replay if you created back end ,it wont be changed based on frend end selections.sorry for before give wrong expected values.
Vendor Name | ITEM_ID | Max Date | Vendor Price |
HCUWDKAI-UWGW PPXYGVDKHEXDH BPC. | 37031 | 07/03/2014 | 0.12 |
ZHIXAJQEXEU-IJUA | 37031 | 04/03/2011 | 0.08 |
LDXG OMDMGXUK | 37031 | 03/12/2012 | 0.11 |
DAOIPVNZ UBSMUEBPJ | 37031 | 01/03/2011 | 0.17 |
HRIOQ LVWLC AVVZTYARYM US., RCY. | 37031 | 19/03/2014 | 0.16 |
Thanks Manish,
sorry i given wrong values,
please find below expected result values.
Vendor Name | ITEM_ID | Max Date | Vendor Price |
HCUWDKAI-UWGW PPXYGVDKHEXDH BPC. | 37031 | 07/03/2014 | 0.12 |
ZHIXAJQEXEU-IJUA | 37031 | 04/03/2011 | 0.08 |
LDXG OMDMGXUK | 37031 | 03/12/2012 | 0.11 |
DAOIPVNZ UBSMUEBPJ | 37031 | 01/03/2011 | 0.17 |
HRIOQ LVWLC AVVZTYARYM US., RCY. | 37031 | 19/03/2014 | 0.16 |
Thanks
I Don't like it, but it works
My Arkusz1 is "master calendar" you may do in script.
I hope it helps!
regards
Darek
Here is version1, with FirstSortedValue.
I think, it should be better
regards
Darek