Hello friends, Hope all is well!
Please look at the image. The last column has the formula: =CALCULATE(SUM([VALUE]),FNDB[Name]=" Revenue")
As you can see it works, but I want the formula to be adjusted to show the “ Revenue” result applied on all cells; i.e. blanks to be
Filled with the Revenue result on all the cells that relate to the data of Branch and year.
Please help me; and thank you so much in advance!
Bookmarks