how do I find the average for each year's family income? it is from year 2000-2020.Thank you!
[2000 data sets](https://i.stack.imgur.com/3dliG.png)
[2001 data sets](https://i.stack.imgur.com/fH3gX.png)
[fields](https://i.stack.imgur.com/cFOnv.png)
I tried using AVG however the field says that aggregated functions are only supposed when included in a level of detail expression.
you can load the data in Prep and use the Aggregate operation :