Matrix table relationships with Columns

[iainh]

Hello, 

In a matrix table we included a breakdown of a structure (i.e., Business Area, Project Teams and finally Projects Numbers) with several dynamic performance metrics based off measures. The aim was to look at the collated performance of Business Areas, then the contribution by Project Teams and finally by Projects themselves.

The Business Area, Project Teams were contain in a Hierarchy Table against a ID field (numerical value) with a 1:1 relationship to the primary project table which contained the Project Number (linked via a corresponding ID field).

When the Project Numbers were taken from the primary relationship data table all the page filters and data relationships (1:1) broke and all Project Numbers were displayed under all Business Area & Project Teams. To resolve this I used the duplicate Project Number in the Hierarchy Table and used that in the Matrix Table columns but its still ignore the page filters so I had to replicate them (and add some ad-hoc ones) into the Matrix Table.

I thought it was strange and wanted to raise it in case this wasn't intended.