Substract based on row and column label

[Cferron]

I have to table that I have to substract value from base on a row / column label to create another table.

I'm basically merging (calculating) two pivot tables
N4 cell value should be: =(B6-B18)*M3
But sometimes pivot table are changing depending on source data. I would like formula in 3rd table to "detect" that.


What function / formula can be made to achieve that?

Thanks!

 

[Alex Blakenburg]

You should be able to do that with a GetPivot formula.
If you click in N4 then type equals (=) > Then click on B6 > type minus (-) > then click on B18 > hit enter
If you get the GetPivot formulas then show us what you get by clicking on the XLS button and posting in the formula.

 

[Cferron]

Yes! I was trying to do it with Excel365 online but the GetPivot formula wasn't automatically writing itself. I have tried in normal Excel desktop app and the formula "populated itself in the cell. This makes it a lot more easier to use this function. I should be able to go from there.

Thanks for looking into this.

Claude

 

[Alex Blakenburg]

No problem. Come back to us if you need help converting the GetPivot formulas to using cell references.