Yes by year.
I have 2 tabs. One that has the input form and charts,
2nd tab is a list of details about the input.
I have 2 sheets.
My app, inputs the number of swipes of a metro card by the reason for the travel.
A total amount of metro expenses is then adjusted to show a percentage and amount per category of travel.
I added a math column to pull the year out of 1 sheet and tried a relation column to the other. But can’t figure out how to have the user select a year (from a a dropdown is fine) and have the charts update to the year selected and have the data for that year appear (which is in the other tab)