Forum Discussion
Calculate different values in one column based on different % that results from another matrix
- Anonymous4 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
You are calculating percentage of row total (across all months). Are you sure about that? Don't you want to calculate the percentage of parent total (single product and single month) ?
I guess it can also work to calculate the percentage of parent total