# 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

Thank you in advance!

Last edited:

### Excel Facts

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.

#### 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:

Replies
31
Views
2K
Replies
3
Views
359
Replies
3
Views
415
Replies
8
Views
221
Replies
6
Views
432

Threads
1,171,359
Messages
5,875,138
Members
433,103
Latest member
inferno657

### 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.
Allow Ads at MrExcel

### Disable AdBlock

Follow these easy steps to disable AdBlock

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

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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