Using multiple operations in Calc with a DSUM formula returns Err:504 for every cell. The idea is to summarise data by two factors (in the attached example, summarising expenses by person and item). This works correctly in Excel (as a data table), but not in Calc. Is this a bug, or something different in Calc?
Untitled 1.ods
Not sure the MULTIPLE.OPERATIONS() function is even supposed to work like that. In Excel the Table thing might, but…
Use a pivot table, i.e. select/mark the data range, then menu Data → Pivot Table → Insert or Edit, confirm Current selection, drag Item to Row Fields, Who to Column Fields and Amount to Data Fields, hit OK. (or set a different destination starting cell first to have the pivot table on the same sheet).
I can’t see the MULTIPLE.OPERATIONS() function available in calc wizard neither in the help .
Thanks for the answer. In this case, I didn’t want to use Pivot Table as I wanted to manually control the row and column field values (including having some values that didn’t occur in the data). Looks like I’m stuck with Excel, unfortunately.