Further advance filtering on Charts

[OsmandFernando]

Dear @PowerAddict 

Based on your and others wonderful support I made the following, 

1. Collection to find sales by location
2. Collection to summarize the sales by location
3. Chart to show the summary sales by location 

I want the location chart to filter based on the Year selection in the dropdown. In the location summary the SalesYear column has under the group. I tried following way but did not work

If(Dropdown2_1.Selected.Value="All",SalesSumbyLocation,Filter(SalesSumbyLocation, Grouped.SalesYear = Text(Dropdown2_1.Selected.Value)))

It says under the = sign invalid argument type 

Kindly help

Osmand

[iAm_ManCat]

You're welcome! Happy to help 😺

Your App is coming along nicely!