# Powerpivot excel 2013 calculated field

#### maggie.hongmk

##### New Member
Hello,

I am trying to create a calculated field. Below is a sample of how my data looks like in the powerpivot.
Retail 1 and Retail 2 are value fields. I want to have 2 columns (see below what column 1 and 2 should calculate)

Column 1 = calculate for retail 1, what the % of the application WITHIN a brand is as a % of the brand total. In this case, 292/341 and 49/341
Column 2 = calculate for retail 2, what the % of the application WITHIN a brand is as a % of the brand total. In this case, 281/499 and 218/499

Brand Application Retail1 Retail2 Column 1 Column 2

Coke Beast 292 281 =292/341 =281/499
Coke CAS 49 218 =49/341 =218/499
COKE Total 341 499

Sprite Beast 115 107 =115/142 =107/251
Sprite CAS 27 144 =27/142 =144/251
SPRITE Total 142 251

Last edited:

### Excel Facts

Easy bullets in Excel
If you have a numeric keypad, press Alt+7 on numeric keypad to type a bullet in Excel.

#### maggie.hongmk

##### New Member
Hello,

I am trying to create a calculated field. Below is a sample of how my data looks like in the powerpivot.
Retail 1 and Retail 2 are value fields. I want to have 2 columns (see below what column 1 and 2 should calculate)

Column 1 = calculate for retail 1, what the % of the application WITHIN a brand is as a % of the brand total. In this case, 292/341 and 49/341
Column 2 = calculate for retail 2, what the % of the application WITHIN a brand is as a % of the brand total. In this case, 281/499 and 218/499

Brand.....................Application............Retail1..........Retail2.........Column 1.........Column 2

Coke........................Beast.......................292..............281.............=292/341............=281/499
Coke.........................CAS.........................49...............218..............=49/341............=218/499
COKE Total.............................................341..............499

Sprite........................Beast.......................115..............107.............=292/341............=281/499
Sprite.........................CAS.........................27...............144..............=49/341............=218/499
COKE Total.............................................142..............251

Last edited:

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

1,167,958
Messages
5,856,520
Members
431,820
Latest member
Tori Murphy

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back