Hello All,
Hope you all doing fine, I have this issue today where I have some sales values with me and I have to create a pivot based on it, Here is the sample data set.
Table1:
OECODe | Name | Company | Sales |
111 | Sid | 1500 | |
111 | Sid | Ebay | -1500 |
111 | Sid | 5000 | |
222 | Pradeep | Amazon | 2000 |
333 | Nitin | Zara | 3000 |
Result Table:
OECODe | Name | Company | Sales |
111 | Sid | 5000 | |
222 | Pradeep | Amazon | 2000 |
333 | Nitin | Zara | 3000 |
So, From the above I have table 1 data with me it contains some negative values which should Nullify while summing all the values.
Help me with this all.!!!!
Regards,
Sid
Solved! Go to Solution.
Hello Dan,
Sorry to trouble you more. Your solution worked perfect but there is one more condition just adding that here. have a look
Table1:
OECODe | Name | Company | Sales |
111 | Sid | 1500 | |
111 | Sid | Ebay | -1500 |
111 | Sid | 5000 | |
222 | Pradeep | HP | 900 |
222 | Pradeep | Amazon | 2000 |
333 | Nitin | Zara | 3000 |
We need to take only whose sales is greater than sales>1000
So result would be same but need to incorporate this condition
Result Table:
OECODe | Name | Company | Sales |
111 | Sid | 5000 | |
222 | Pradeep | Amazon | 2000 |
333 | Nitin | Zara | 3000 |
The new one checks if the absolute values of the sales is >=1000. The ABS(SALES) is to avoid removing the negative rows.
Dan
Awesome! We hit it! Thanks a ton Man!