Käynnissä

Excel pivot table

I need to create two pivot tables.( Microsoft Excel) I need to have formulas made.

First formula needed-

My report for part sales looks like this. it can have thousands of entries so I need excel calculate them.

part# amount sold

12345 1

12345 2

12345 1

12345 3

62542 1

66621 2

Calculation outcome will look like this.

part# total sold

12345 7

62542 1

66621 2

Second formula Example

part# total sold part# cost of each

12345 7 12345 = $[url removed, login to view]

62542 1 62542 = $[url removed, login to view]

66621 2 66621 = [url removed, login to view]

Calculation outcome will look like this.

part# total dollars sold of each item

12345 = $[url removed, login to view]

62542 = $[url removed, login to view]

66621 = $[url removed, login to view]

Taidot: Excel, Microsoft

Näytä lisää: microsoft excel formulas, sales excel, pivot tables, pivot table excel, excel pivot, excel pivot table, excel calculation, excel 2013 formula, microsoft excel 2013, look table excel, pivot report, create excel formulas, excel sales, need excel, microsoft excel sales report, create excel table, pivot table report, excel formula table, pivot table formula, formulas excel, tables excel, calculate sales excel, excel entries, formulas sales report excel, sales report excel

About the Employer:
( 1 review ) laguna hills, United States

Projektin tunnus: #4302366

Myönnetty käyttäjälle:

codemannz

I have years of experience with Excel.

30 $ USD 1 päivässä
(2 arvostelua)
1.6

4 freelanceria on tarjonnut keskimäärin 60 $ tähän työhön

satsin7

Hi I love creating pivot tables and charts.

30 $ USD 1 päivässä
(13 arvostelua)
4.4
mandeeps207

Hi there, Very simple project ready to finish right now.....

30 $ USD 0 päivässä
(15 arvostelua)
3.8
sweta11189

i have deep knowledge of excel. i like to work for [url removed, login to view] i do all work in time.

150 $ USD 3 päivässä
(0 arvostelua)
0.0