Hey everyone,
I've got some basic data below to illustrate what I'm trying to do. Essentially, I have a bunch of dimensions, and they each have revenue associated with them. One of those dimensions is site.
I also have external data that shows the total number of impressions for each site.
If I were to pivot the table above, I end up with:
I want to create a calculated field that, for each site, for each advertiser, divides revenue by the total impressions for that specific site. Is there a way to do that with a calculated field?
So in the example above, for site 1, it would do
B3: 1000/25000
B4: 2500/25000
C3: 3000/30000
etc.
I've got some basic data below to illustrate what I'm trying to do. Essentially, I have a bunch of dimensions, and they each have revenue associated with them. One of those dimensions is site.
I also have external data that shows the total number of impressions for each site.
| Site | Advertiser | Revenue |
| Site 1 | Advertiser 1 | $1,000 |
| Site 1 | Advertiser 2 | $2,500 |
| Site 1 | Advertiser 3 | $2,000 |
| Site 2 | Advertiser 1 | $3,000 |
| Site 2 | Advertiser 2 | $1,500 |
| Site 2 | Advertiser 3 | $1,800 |
| Site 3 | Advertiser 1 | $1,200 |
| Site 3 | Advertiser 2 | $1,400 |
| Site 3 | Advertiser 3 | $2,200 |
| Total impressions Site 1: | 25000 | |
| Total impressions Site 2: | 30000 | |
| Total impressions Site 3: | 20000 |
If I were to pivot the table above, I end up with:
| Sum of Revenue | Column Labels | |||
| Row Labels | Site 1 | Site 2 | Site 3 | Grand Total |
| Advertiser 1 | 1000 | 3000 | 1200 | 5200 |
| Advertiser 2 | 2500 | 1500 | 1400 | 5400 |
| Advertiser 3 | 2000 | 1800 | 2200 | 6000 |
| Grand Total | 5500 | 6300 | 4800 | 16600 |
I want to create a calculated field that, for each site, for each advertiser, divides revenue by the total impressions for that specific site. Is there a way to do that with a calculated field?
So in the example above, for site 1, it would do
B3: 1000/25000
B4: 2500/25000
C3: 3000/30000
etc.
