I am trying to create a pivot table within Coda. Can it display one row of SUM totals for grouped fields that I have made my columns and another column of SUMs for my grouped rows? Within the pivot table can it display just the calculated value (e.g. SUM) and not the individual raw values and then the calculated value beside them?
I am working with a table of values with fields that include financial year and quarter of the FY. Using groups and assigning FY to ‘group left’ and Quarter to ‘group top’ I can create the start of a pivot table. But when I select summarise, it generates lots of individual summary calculations - one for each ‘cell’ within the pivot. I can’t seem to find a way to have a single total SUM for each Quarter at the bottom of the pivot and for each FY at the right or left of the pivot. Nor can I get the pivot to display just the summarized value in each ‘cell’ and not the individual records with the SUM beside them.
Grateful for any help.