# 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 = \$10.00

62542 1 62542 = \$14.25

66621 2 66621 = 12.47

Calculation outcome will look like this.

part# total dollars sold of each item

12345 = \$70.00

62542 = \$14.25

66621 = \$24.94

Taidot: Excel, Microsoft

Tietoa työnantajasta:
( 1 arvostelu ) 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 %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% 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