So, I have a pivot table where the rows are ad campaigns, the columns are months, and the Values are Max of campaign status. It looks kind of like this:
The reason that the campaign status is set to Max is that it's always a number one through five, and that number is always the same throughout a campaign. So the sum would not be relevant.
The objective here is to create a third column that shows how the status changed between Month1 and Month2.
I have been playing around a lot with the "difference from" feature, but it doesn't seem to like the fact that I'm using Max instead of Sum. I have also played with adding a calculated field, but such a field regards both month columns as the same field, and I cannot therefore refer to them separately.
This is another situation where I could use the band-aid solution of manually adding a column outside the pivot table and just doing the calculation there. But this is to be a weekly report, and the size of the pivot table is going to change every week. I really want to find a solution that will not require manual adjustment every time the data changes.
Thanks, and happy to clarify if necessary.
Code:
MONTH1 MONTH2
CAMPAIGN1 1 2
CAMPAIGN2 3 4The objective here is to create a third column that shows how the status changed between Month1 and Month2.
I have been playing around a lot with the "difference from" feature, but it doesn't seem to like the fact that I'm using Max instead of Sum. I have also played with adding a calculated field, but such a field regards both month columns as the same field, and I cannot therefore refer to them separately.
This is another situation where I could use the band-aid solution of manually adding a column outside the pivot table and just doing the calculation there. But this is to be a weekly report, and the size of the pivot table is going to change every week. I really want to find a solution that will not require manual adjustment every time the data changes.
Thanks, and happy to clarify if necessary.
Last edited:
