Noxqss38242
Board Regular
- Joined
- Sep 15, 2017
- Messages
- 223
- Office Version
- 2016
I have 39 different systems I'm tracking. Each month a cost report is made. I calculate what the difference is for each system per month.
IE: Engine cost X last month, Y this month and the difference is Z.
So I have this data in a separate section:
BRKTRA ($4,283)
BRKTRL $5,365
CRNKSY $12,427
HVAC ($235)
TLMISC ($5,830)
and so on...
I want the graph only to pull the system and the cost difference ONLY if the difference is greater than $5,000 or ($5,000)
That way the chart should only contain a handful of systems with the difference instead of ALL the systems with the difference.
The chart shouldn't pull HVAC or BRKTRA as an example listed above. Is this possible? If not, please also let me know. Thanks again!
IE: Engine cost X last month, Y this month and the difference is Z.
So I have this data in a separate section:
BRKTRA ($4,283)
BRKTRL $5,365
CRNKSY $12,427
HVAC ($235)
TLMISC ($5,830)
and so on...
I want the graph only to pull the system and the cost difference ONLY if the difference is greater than $5,000 or ($5,000)
That way the chart should only contain a handful of systems with the difference instead of ALL the systems with the difference.
The chart shouldn't pull HVAC or BRKTRA as an example listed above. Is this possible? If not, please also let me know. Thanks again!