Excel Create a pivot table
11 USD 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)
Applications 1
Client's review of cooperation with Andrii Panichuk
Excel Create a pivot tableVery quickly got in touch and promptly completed the work. I recommend!
Freelancer's review of cooperation with Yevhen Inchevsky
Excel Create a pivot tableClear task, quick check.
It's good when there is an understanding of what a person wants.
-
1 day11 USD
561 15 0 1 day11 USD
Good night! I have been working with spreadsheets for a long time, so I will do everything quickly and efficiently, according to your wishes.
-
Winning proposal1 day11 USD
2536 51 1 Winning proposal1 day11 USD
Let's make all your tables)
----------------------
Sincerely,
Andriy
-
1 day11 USD
500 3 1 1 day11 USD
Good day.
I have experience in filling out tables and formulas.
I can complete your task.
-
1 day11 USD
214 1 day11 USD
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.
Current freelance projects in the category Databases & SQL
Need an Airtable architect to build a relational schema and a new clean Airtable base.Need help rethinking and building a clean relational schema for an internal operational system on Airtable. The current database is already in use by the team, but it has grown organically: the structure is partially flat, some tables/views are actively used, while others are… Databases & SQL, Desktop Apps ∙ 4 hours 56 minutes back ∙ 7 proposals |
Basketball Coaching Education Platform + Custom CMSBasketball Coaching Education Platform + Custom CMSProject Overview We are looking for an experienced web development team or full-stack developer to build a modern basketball coaching education platform. The website will provide basketball coaches with access to educational… Databases & SQL, Web Programming ∙ 22 hours 29 minutes back ∙ 78 proposals |
Integration of Viber in 8.3
223 USD
Need Viber integration into own CRM (1C 8.3)About the Company The company "Domofon System" is engaged in the installation and maintenance of intercom systems. Base of over 40,000 subscribers. We work on our own customized system based on 1C 8.3. We are looking for a specialist… Databases & SQL, Bot Development ∙ 1 day 1 hour back ∙ 13 proposals |
Refinement of 1C UT 11 for Zebra TSD (RDP): different sound signals when scanning
22 USD
Configuration: 1C UT 11 Address warehouse Zebra TC26 TSD Work via RDP Product scanning is performed in receiving, placement, picking documents, and other warehouse operations. Current problem: Warehouse workers operate through the Zebra TSD. When scanning, they do not always… C#, Databases & SQL ∙ 2 days 23 hours back ∙ 6 proposals |
Heal the 1C configuration
111 USD
Configuration of CRM & ERP SmartCeiling (2.8.26.0) Protection via Registration Code. Registered until the end of the year. Databases & SQL ∙ 3 days 14 hours back ∙ 8 proposals |
Odessa