Hello Thank you for sending me the xml. This works for me too but when I add the other pay elements in, the table view works but the pivot doesn't. It needs to be a pivot I think so the other pay elements automatically go across as element names rather than in a table with duplicate rows per employee. When I add the pay…

Hi Its still not totalling up so not sure what you did you fix it. I tried the server complex aggregate in the formula but it didn't total up in the pivot table - and in the pivot table design there is no aggregate option on that field. I think the issue is that both the salary and Bonus Entitlement Value fields are not…