Hi Tom,

To avoid the elimination of "General contingency" is easy. Just include the Heading column to the equation so that PQ looks for duplicates where both Heading and Description are the same.

The other issues doesn't seem to make much sense. Is this really goin to happen, I wonder? Why would you put 2 identical line items under the same heading. Common sense would suggest you enter 1 row for the Roof covering contingency for 2 items at 20000. but, if what you describe is a real life scenario, you would have to clean-up the tables first and group (summing) such identical rows before merging.

See attached.

Riny

Hi Riny

This is great thank you. I can't think of any more tweaks.

The other issues doesn't seem to make much sense. Is this really goin to happen, I wonder? Why would you put 2 identical line items under the same heading.

This is useful because sometimes I am working with unrefined data, so someone might have left a duplicate in the table and I would get caught out if I forgot to Pivot it myself. Your excel captures this request.

Tom

Hi Riny,

Could you please let me know if your technique of showing differences between group totals could work in the advanced set-up I have tried to describe in the attached?

Thank you

Tom

Oh, but this is completely different. I focused on the desired pivot table and ignored the intermediate table as much of the information is not needed. Also took the liberty to clean-up the data table as it isn't best practice to use structured tables that include empty rows and columns and sub-headers withing the table. That made the PQ a lot easier.

See if this does what you need.