Powerpivot excel 2013 calculated field

[maggie.hongmk]

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!

 

[maggie.hongmk]

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