We have two tables one is having product and its value.
Other has expected sold numbers by year
We need a final table like below, in which three columns are added as there are there years, if more years then more columns.
Every new column is formula i.e (Year Sold Value)*(Package Unit Value)
Anything helps, I have trying Formula and Multirow formula but not getting my desired result.
Solved! Go to Solution.
Thanks, that's what I was looking for, It worked
Great ! no worries @atifsharif 😄