Creating a pivot sheet in libre office

Closed job
no avatar
Antoni
Employer
Job category:
Data processing
Expected budget:

Negotiable

Published:
Valid until:

Job description

The sheet has to store a database of customer orders and assign customers to different groups of customers and then according to these groups assign the order to a particular shipping employee, please use the data on the basis of customer A,B,C,D / product butter, bread, egg, etc....

I need to be able to easily generate a mailing list of customers in a csv file also according to a given group of customers

Please do not accept the order if there are any doubts about the implementation Only libre office Only serious orders, I am interested in a fast turnaround time

DATA is let's assume

ORDERS

customer email, product name, product quantity (there may be several products - I do not know how to solve this), package code, order number, status (shipped, not shipped)

(assigning to a particular shipper on sheet #2 according to filters),

PRODUCTS

product x / in quantity from 1-20000

product y / in quantity from 1-20000

product z / in quantity from 1-20000

CUSTOMERS

customer email and more to be discussed with selected contractor

The job in figures:

libre office