Get field from chart table and use it in a pivot table

[Anonymous]

Hi,

I face a problem that I can't solve.

I have a chart table that contains years an a contract values.

Below that chart table I have an other Chart Pivot.

In that pivot table the contract value chould not split up by drilling down but needs to have the same value (7915) as in the chart table (See attached screen capture).

So to be clear every contract value in claim year 1 should have the value 7915.

Does someone have a solution for this?

Thx,

[Anonymous · Accepted solution]

Hi,

Solved the problem with set analysis

/m