Forum Discussion

harshadrokade's avatar
harshadrokade
Post Partisan
6 months ago
Solved

Table visual with data from Data tab + measures

Hi,   I have below data.    Project name 1-May-25 1-Jun-25 1-Jul-25 1-Aug-25 1-Sep-25 1-Oct-25 1-Nov-25 1-Dec-25 1-Jan-26 A 23 39 14 20 14 17 33 35 36 B 14 37 28 35...
Need Help
harshadrokade's avatar
harshadrokade
Post Partisan
6 months ago

Data is same as I shared in first port.

Logic for Forecasted value-
Assuming I have a column with the actual values for each month:

 

Month Value

Jan100
Feb120
Mar140
Apr160
May180

 

I will calculate the average monthly growth rate as follows:

  1. Calculate the growth rate for each month:

    • Feb: (120 - 100) / 100 = 20%
    • Mar: (140 - 120) / 120 = 16.67%
    • Apr: (160 - 140) / 140 = 14.29%
    • May: (180 - 160) / 160 = 12.5%

  2. Calculate the average monthly growth rate:

    • (20 + 16.67 + 14.29 + 12.5) / 4 = 15.89%

  3. Calculate the forecast for the 6th month:

    • Forecast = 180 * (1 + 15.89/100) = 208.60
  • harshadrokade's avatar
    harshadrokade
    Post Partisan
    6 months ago

    I wanted to add YTD also After Jan26. 
    Also Is there a way to highlight Feb and March as Foorecastred months in header?

     

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      6 months ago

      Do not know how to add the YTD column.  Not sure of how to colour te header but you can colout the value