You could try using the column labels in your expressions - although not dimensions they should still work e.g.
=if([Negative Delta]<0,sum(Total <SubType> if(Sales-Target<0,Sales-Target,0)),0)
as in attached example, [Negative Delta] is a column name.
They figures don't match your spreadsheet exactly as it seems to be selecting only 2 Agents at a time, e.g. cell K6 shows -32 rather than
-40 as the Agent C's value is not included. Are only pairs of agents to be compared ?,
Sales Quotas.qvw 139.0 K
Hi Jonathan and HDonald,
thank you for your suggestions: at the end I've understood that I cannot use sum[Delta] because are not linked with dimensions (as soon as possible I want to go in deep with this issue), and that values on that column has to be treated separately cell by cell.
I've used formulas based on rowno() and noofrows() in order to create a column with incremental values per agent and another column with total per agent repeated on each row. It's a brute force approach, but it works fine!