In my external database, I have a table with this structure:

Employee / Dept / Salaries

Under the Dept, I will, of course, have different departments like Finance, Logistics, Sales, Marketing, Production, etc. Here are the questions:

1. How do I create a calculated field based on the department? E.g. I would like to make a budget for Marketing which is 10% of Sales+Marketing salaries. Logistics budget will be Production+Logistics salaries + 15%. I don’t want to use the IF formula as my experience tells me that Pivot formulae do not calculate on individual records but aggregates.

2. How do I apply Calculated Items? I have gone through the Help file but find the examples very inadequate. In my case, my calculation would be dependent on other items within the field, not the same item.

Thanks in advance.