1. Create a pivot table on a separate sheet. Display the data (average price and total quantity) by city-category-product, add the remaining fields to the filter

2. Combine the categories oil and butter into one category "Fats", hide the field "Sweets"

3. Create a calculated field "Total Sales" = price * quantity

4. Add a field with the standard deviation of price

5. Create a separate pivot table by region with the total sales indicator

6. Pull the total sales for the corresponding region from the pivot table to the data table using a formula (column I)

Proposals 4

Please select

Oksana T.

15 0

Projects 15
Rating -
Rating 561

Budget: 500 UAH Deadline: 1 day

Good night! I have been working with spreadsheets for a long time, so I will do everything quickly and efficiently, according to your wishes.

Andrii Panichuk

Winning proposal

51 1

Budget: 500 UAH Deadline: 1 day

Let's make all your tables)

----------------------
Sincerely,
Andriy

Yurii Rudenko

3 1

Budget: 500 UAH Deadline: 1 day

Good day.
I have experience in filling out tables and formulas.
I can complete your task.

Viktoriia Sobetska

0 0

Projects -
Rating -
Rating 190

Budget: 500 UAH Deadline: 1 day

Hello!
I am ready to fulfill your request. I have experience in formatting tables. I can do it quickly and efficiently. I suggest discussing the details or immediately agreeing on collaboration.

Yevhen Inchevsky
Odessa, Ukraine

Projects 15
Rating 5.0
Rating 306

Excel Create a pivot table

Client's review of cooperation with Andrii Panichuk

Excel Create a pivot table

5.0

Yevhen Inchevsky

Freelancer's review of cooperation with Yevhen Inchevsky

Excel Create a pivot table

5.0

Andrii Panichuk

Oksana T.

Andrii Panichuk

Yurii Rudenko

Viktoriia Sobetska

Proposals are currently absent

Current freelance projects in the category Databases & SQL

Automation of the entry of income invoices in 1C 8.3 via the API of the document recognition service

Senior AI Systems Architect (Project Lead) Needed to Complete an Existing Unfinished Global Service

Development of the CRM module "Requests" in custom 1C (bus center)

Support for Samotur and its servers

Cleaning the client database in SIMLA CRM: phones, duplicates, cities