I have a spreadsheet with line items from Invoices, and each record contains the fields UnitPrice, Quantity, Discount and Freight. I want to perform some analysis, and a TABLE usually fits this bill.
I saw a video on YouTube that demonstrated the calculated column functionality while in a TABLE that then automatically populates that column with the formula. Then, when wanting to use Subtotals (not supported in TABLE) I converted to a normal range. At this point the TABLE formulas changed to formulas containing cell references, as expected.
However, now any time I sort the data, all the cells to the left of the calculated column sort as desired, but the calculated column stays stagnant, and the cell references change to where the data that made up that calculation moved in the switch. I have ensured that all the data is selected when doing a sort.
Has anyone run into this? Know of a solution other than performing all calculations outside of the TABLE functionality?
I saw a video on YouTube that demonstrated the calculated column functionality while in a TABLE that then automatically populates that column with the formula. Then, when wanting to use Subtotals (not supported in TABLE) I converted to a normal range. At this point the TABLE formulas changed to formulas containing cell references, as expected.
However, now any time I sort the data, all the cells to the left of the calculated column sort as desired, but the calculated column stays stagnant, and the cell references change to where the data that made up that calculation moved in the switch. I have ensured that all the data is selected when doing a sort.
Has anyone run into this? Know of a solution other than performing all calculations outside of the TABLE functionality?
