Forum Discussion

OscarDOSSANTOS's avatar
OscarDOSSANTOS
Frequent Visitor
4 years ago
Solved

Calculate different values in one column based on different % that results from another matrix

Good evening everyone, Thank you for reading my post I hope you can help me for this really specific case!   I sell products in different countries with different specifications. Here I created a ...
  • Anonymous's avatar
    Anonymous
    4 years ago

    HI OscarDOSSANTOS,

    According to your description, it sounds like you want to get the per month forecast instead of total values. If that is the case, I'd like to suggest you manually process these.
    You can get the current year forecast and manually extract aggregate date values on the current cell, then you can use the total month count to calculate with summarized total values. (per month forecast = year total /12, current forecast = per month forecast * current aggregated month amount)
    Regards,
    Xiaoxin Sheng