Pivot table,added a new used field,not showing values

[#1]

Hi All,

In Pivot table,added a new used field(Test Cycles).The table values not getting aggregated when this used field(Test Cycles) is selected.

In image below,Test Cycles is new used fields,All values showing same for each Test Cycle row.

Whereas  with an exsisting used field , Project shows values as below.For each we get different vaues as shown in image below.

Columns...Passed,Failed,Complete,N/C,Blocked........ are expressions set as in below image.

Please advise,let me know any more information needed.

[Gysbert_Wassenaar]

That looks like the result of a cartesian product. That can happen when you add a field from a table that's not linked to any other table in your data model.