Vendor Price Calculation

[Anonymous]

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.

[MK_QSL]

Can you check the Required Result you have mentioned in excel file is right or not?

[its_anandrjs]

Your required result is not please provide more info also check field names.

Regards

[its_anandrjs]

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

[Anonymous]

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

[Anonymous]

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

[#7]

I Don't like it, but it works

My Arkusz1 is "master calendar" you may do in script.

I hope it helps!

regards

Darek

[#8]

Here is version1, with FirstSortedValue.

I think, it should be better

regards

Darek