Sum or average of values in 1table using fields common from other table

[Veq21984]

Hi All,

I have 2 tables namely: Masterlist and Production

Masterlist Fields: Country, Zone, FuelType, Name, OtherDetails

Production Fields: Date, Hr, Minute, Name, Production

How can I graph using sum or average the production per Month per Country?

Filters used: Year

I Tried using the following formulas but no graph was displayed because of undefined source

Dimension: Month(Date)

Measure: Avg({<Country = Country>} Production)

Any help please

[Lisa_P · Accepted solution]

If Name is the common field, it should be the association between the two tables, so just Avg(Production) with Dimension1 as Month(Date) and dimension2 as Country

[Veq21984]

Got it... Thanks for the idea.

Now I create 2 charts, Piechart and bar chart

How can I make the Piechart (slice:zone) as sort of filter of the bar chart? Where if I click a specific slice of the pie the bar chart will display the values for the zone selected in the piechart?

How can I make connection of the 2charts?

1. Pie chart as filter

2. if bar chart is clicked, pie chart will not be affected. Only piechart selection will affect the other graph like some sort of filter