Forum Discussion

laetitiaf's avatar
laetitiaf
Frequent Visitor
1 year ago
Solved

Show Future KPI Values

Hi Guys, 

 

I'm wondering if it's possible to take the overstock value from the first month of this year, divide it by 12 and use to determine the Target value for the next 12 months. 


EG. 
Overstock 01/2025 = $4,658
Target 01/2025 = $4,270
Target 02/2025 = $3,881

Target 03/2025 = $3,493

Target 04/2025 = $3,105

Target 05/2025 = $2,717

Target 06/2025 = $2329

...
Target 12/2025 = $0

 

(Decline of about $388 per month, but this value needs to be dynamic depending on what filter is used)

Looking for the visual to end up looking like something similar to the below, with the blue line added.

 

Model looks like below

 

3 Replies