Different 'Delivered' value in one location ??

[chanin7893]

Hello Everyone,

I have an Excel sheet with 5 Different Values: 

• Location
• Work_Location
• Week
• Expected
• Delivered

These are the values for 14 Locations.

For the Expected values, the values are coming correct.

However for the Delivered values, a small change has to be made for Location 'PPP'

 The Delivered values don't appear directly in 'PPP'. To obtain those values, we have to Deselect 'Location' as 'PPP' (i.e. no selections made on 'Location') and Select 'Work_Location' as 'PPP' and then we recieve those 'Delivered' values for Location 'PPP' (We actually then copy paste those values in the 'Delivered' section of Location 'PPP').

So I wanted to know is there any code that can be written in either the Back end or Front end to get this Location 'PPP' issue sorted out.

I have attached a sample Excel sheet for better understanding.

[timpoismans]

Hi,

a few questions to start with:

• Do you want to keep all 5 fields from your excel in the final table?
• When work_location = 'PPP', the location = 'MMM'. This doesn't matter when copying the Delivered values?

Regards,

Tim P.

[chanin7893]

Hi,

Thanks for taking the Time to reply

Answer to the 1st Question : No, I will not be keeping the 'Work_Location' in the Final Table. The 'Work_Location' field will be a filter.

Answer to the 2nd Question : Not necessary, the 'Location' can be anywhere, but even if you can provide me a solution for 'Location' = 'MMM', that will be great.

Thanks again.

[chanin7893]

Any Update on the solution ??

[timpoismans]

Based on the example excel you've attached, what would your expected output be?

Do you want the 5,3,6 for Week2, 3 and 4 respectively to be applied for every PPP location? (So something like this?)

PPP	PPP	Week 2	0	5
PPP	PPP	Week 3	0	3
PPP	PPP	Week 4	0	6
PPP	-	Week 2	2	5
PPP	-	Week 3	2	3
PPP	-	Week 4	2	6

Regards,

Tim P.