Dual Line Graph based on selection

[MIKIEMILLER]

Hello,

I want to make a line graph that has two lines.  The dimension will be the Year.  When you click on a specific unit, one line will show that units total Type B value for each year, and a second line will show the average county type B value for each year.  Below is a small sample of the data.  There are more units, and counties that just this.

I would appreciate any help.

[sunny_talwar · Accepted solution]

I used these two expressions

1) Sum({<Type = {'B'}>}Amount)

2) Avg({<Type = {'B'}, Unit, County = p(County)>}Amount)

[MIKIEMILLER]

I think that worked.  Thank you again.