Urgent Help on Matrix

[Anonymous]

Hello,

I have 14 tables they are individual KPI tables with date,country and Actual values. Additionally i have created 3 tables one for Date,country and Target.

I am creating a Matrix visual. I am able to get categories and sub categories and metrics as an hierarchy in rows. Target is added separately in values. However when i add Actuals it is actually getting added as a separate columns. Please tell how i could add the average correctly. 

Example: 

Category   Sub-cat  Actual  Target

A                  aa          55         100

B                  bb          60         100

I want it in above format but it is coming in below format

Category   Sub-cat  Actual  Actual Target

A                  aa          55                  100

B                  bb                      60      100

Please help

[PaulDBrown]

@Anonymous 
What is the structure of your tables?

[Anonymous]

I have 14 Indivual KPI tables with Metric name, country, date, Actual value.

I have created 3 tables Country, Date, Target

Country table links to kpi tables on country.
date table links to kpi tables on date.
Target Table links to Kpi tables on Metric name.

[PaulDBrown]

@Anonymous 

it is going to be difficult to help solve the problem without seeing a sample of your tables (with false data if need be).

are the sum of actuals in your matrix summing up values form different columns?

[Anonymous]

I can pm you the pbi file.