Hi,
I made an app for our farm to record planting, fertilizing, harvesting, etc. all with the common denominator of $/acre.
I made a summary tab with 1 column, listing every single field, and then made lots of virtual columns with planting, etc. using expressions like โSUM(SELECT(Planting Data[Cost per Acre],[Field]=[_THISROW].[Field]))โ in the app formula.
When you open up the app, you can select the Field, then all the costs for planting, fertilizing, harvest, etc. are there.
This works!!
Except now that we are on our 2nd year, it is returning all our data from 2017 and 2018, which makes that โat a glanceโ feature useless.
How can I make it so that after we select โFieldโ, we can select โYearโ and then have only data with that year in it display?
Iโm guessing I need a new virtual column, and Iโm prepared to redo the rest of the virtual columns.
(They need reordered anywayโฆ)
I appreciate any ideas you can offer!
Valerie
LinkedIn
Twitter
