Dimension level if else condition help

[ajaykumar1]

Hi Everyone,

I need some help to get the below requirement and the data is like below.

Input:

Part	OrderNo	OrderLineNo	CHARGETYPE	Cost
Samsung	88733	1		498
Melkco	88733	2		3
Other	88733	9000		0
	88733	1	SamsungDAC	-20
	88733		Frakt	5

Logic:

Based on the OrderNo and OrderLine No need to fill the blanks in Part field.So below sample output.

Part	OrderNo	OrderLineNo	CHARGETYPE	Cost
Samsung	88733	1		498
Melkco	88733	2		3
Other	88733	9000		0
Samsung	88733	1	SamsungDAC	-20
	88733		Frakt	5

Final Out Put :

When am selecting the samsung value in Part field then i need to get the below output.

Note : Here no need to consider the Chargetype is blank.So only -20.

Part	Cost
Samsung	-20

Note : I need to do this mainly in front end level only because of all the fields are coming multiple tables.So its very difficult to touch the data model.

Eagerly waiting for someone response to save my day 🙂

More Thanks,

Ajay

[MK_QSL]

It is difficult to get Part Samsung for same OrderLineNumber and OrderNo at front end. You can get the Name Samsung for Part field in script end.

[ajaykumar1]

Thanks Manish.

I need to get this in front end itself.Anyway can you help me how to resolve this script level.

More Thanks,

Ajay

[MK_QSL]

FYI

[antoniotiman]

Hi,

try to use Calculated Dimension instead of Part

Aggr(MaxString(Part),OrderNo,OrderLineNo)

Regards,

Antonio

[Kushal_Chawda]

Hi,

I have done this in front end but not sure if this is good approach.

But for now it will help

[ajaykumar1]

Thanks Manish...Its looks working fine through script.

Is it actually possible from front end?

More thanks,

Ajay

[ajaykumar1]

Thanks Kush.But its not working.

If am selecting samsung in part level its showing 498 which is wrong....I want -20.

Thanks,

Ajay

[Kushal_Chawda]

Hi Ajay,

I have done some modification. Please check it out.

[Kushal_Chawda]

Hi Ajay,

I think best way to do it from front end is suggested by ANTONIO MANCINI with slightly changing the expresion