We need something visual that shows us our total closing amount for the fiscal year. It doesn't matter what kind of Target meter or chart it is. I KNOW how to create a target meter with a static Target. However, we need the "Target" amount to increase by $25,000 every month.
So for:
- January the Target is $25,000
- February $50,000
- March $75,000
- April $100,000
- ... and so on through December
Each "amount" in "closed won" deals in that fiscal year counts towards our Target. But every every month the Target also increases by $25,000.
For example:
JANUARY
- Won $20,000 in closed deals.
- Target: $25,000
FEBRUARY
- Won $15,000 in closed deals for a total of $35,000
- Target: $50,000
MARCH
- Won $40,000 in closed deals for a total of $75,000
- Target: $75,000
Can we increase the Target/Goal each month by an additional $25,000 automatically?