Hi all,
I have a pretty simple problem - I wish to create a calculated field in my pivot table. This calculated field needs to SUM two fields, that already exist in the data source, but with a little twist. Here is an example which will make this much more clear.
Source data:
<tbody>
</tbody>
The result pivot table that I need to create:
<tbody>
</tbody>
The problem:
In the source data, field:Mobile app sales $ needs to be divided by 2 IF field:Platform equals "iOS". (We have a data collection problem that cannot be corrected for now so I have to make do). Yes, I know that one option is to simply intervene in the source data sheet but I wish to avoid that as much as possible. Pseudo-formula would look like this:
This is what I tried but it's not working:
If I solve this on the pivot table side, then I can simply refresh my source data with new .csv imports which I append to the end of existing data.
Many thanks!
Alex
I have a pretty simple problem - I wish to create a calculated field in my pivot table. This calculated field needs to SUM two fields, that already exist in the data source, but with a little twist. Here is an example which will make this much more clear.
Source data:
Market | Platform | Web sales $ | Mobile app sales $ |
FR | ios | 1323 | 8709 |
IT | ios | 12434 | 7657 |
FR | android | 234 | 2352355 |
IT | android | 12323 | 23434 |
<tbody>
</tbody>
The result pivot table that I need to create:
Market | Total sales $ |
FR | (Web sales + Mobile sales) |
IT | (Web sales + Mobile sales) |
<tbody>
</tbody>
The problem:
In the source data, field:Mobile app sales $ needs to be divided by 2 IF field:Platform equals "iOS". (We have a data collection problem that cannot be corrected for now so I have to make do). Yes, I know that one option is to simply intervene in the source data sheet but I wish to avoid that as much as possible. Pseudo-formula would look like this:
This is what I tried but it's not working:
Code:
='Website conversion value' +IF(Platform=OR("iPhone"; "iPod"; "iPad");'Mobile app purchases conversion value' /2;'Mobile app purchases conversion value' )
If I solve this on the pivot table side, then I can simply refresh my source data with new .csv imports which I append to the end of existing data.
Many thanks!
Alex
Last edited: