I have a pivot table on sheet 1 and try to make another table with data from the pivot table on sheet 2 (because you can't add columns to a pivot table, can you?). However, if I write a formula like this
Table 1 Pivot::$C$3÷Table 1 Pivot::$B$3−1
as you can see all references are preserved ($). If I manually delete the $, Numbers reinsert them when I confirm the formula.
Why is this? How can I get around it?