Pivot Table Issue

[#1]

Hi All,

I came across this weird issue when using the pivot table. My pivot table is as follows

As you can see the 2nd column can be expanded as required. My problem is when I try expanding the record highlighted in red, the green record also expands. Reason being the field values being the same. I only require the relevant record to be expanded.

I don't know if this is a common issue in the pivot table but if so what is the workaround?

Can anyone help on this matter?

Thanks!

[#2]

can you please check both records data containing fields (In time and Breached) from your table.

[JonnyPoole]

Bit of a guess ... is it different with  aggr( Target, Description) as the 2nd dimension ?

[#4]

Hi Sanjeev,

The data sets for the In Time and Breached are different.

[#5]

Hi Jonathan,

Unfortunately it doesn't work. But thanks for the suggestion.

[#6 · Accepted solution]

Found it! The field 'Target' was included in a dual function. A unique number was given for each Target. Works like a charm.

Special thanks to Brittany Petit's post which gave me the insight into what should be done:

http://dvtrenches.wordpress.com/2011/06/03/ungrouping-in-pivot-tables