I have two values, One Showing How many Upgrades have been completed and how many still need to be completed, I’d like to show a box that shows when a report is refreshed When the Count increases of the upgrades it shows by how many. so if its 500 today and tomorrow 600, there'd be a box that says +100 Upgrades completed since last refresh.
The thing is, im using a measure to count how many rows are labelled with Upgrade Complete.
So right now i have a box shows 2000 Completed, then another measure counting upgrades required which then says 26,000.
When run refresh the counts change but its not easy for people to see ok It went up by 500 this run. So i'd like a box to show that increase like +500 Since last report run.
I was thinking of someway making a new table that stores these counts not sure how , i tried but didnt work.
Then somehow it then remembers those counts from run to run then it can show the difference and/or increase, not sure. hoping some easier way of doing it somehow.
