Powerpivot excel 2013 calculated field

maggie.hongmk

New Member
Joined
Nov 28, 2012
Messages
23
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:

Some videos you may like

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.

maggie.hongmk

New Member
Joined
Nov 28, 2012
Messages
23
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:

Watch MrExcel Video

Forum statistics

Threads
1,122,521
Messages
5,596,653
Members
414,083
Latest member
Mrsash

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

Which adblocker are you using?

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
Top