adding non-pivoted columns to a pivot table
Hi Zoho,
Did some searching around and I haven't found a way to add columns back to a pivot table.
Currently I have a back end query table that contains contracts. For each contract ID there are and invoice date and invoice amount along side extra information about the contract
contract ID | invoice date | invoice amount | extra info 1 | extra info 2 |
00001 | 01/01/2023 | £30.00 | foo | bar |
00001 | 02/01/2023 | £40.00 | foo | bar |
00002 | 01/01/2023 | £15.00 | baz | bell |
I've used the pivot table to get a table like the following
contract ID | 01/01/2023 | 01/02/2023 | .... |
00001 | £30.00 | £40.00 | .... |
00002 | £15.00 | - | .... |
However I would now like to add back the extra information as follows but cannot figure out a way to do this.
contract ID | extra info 1 | extra info 2 | 01/01/2023 | 01/02/2023 | ... |
00001 | foo | bar | £30.00 | £40.00 | ... |
00002 | baz | bell | £15.00 | - | ... |
Any solutions/workarounds would be much appreciated.
Many thanks,
George