Which Formula should be used here?
I have an issue with the way i want to display data.
Balance Yearly branch
123 500 1000 1
456 250 1000 1
789 250 2000 2
Current Balance yearly goal
I want it to be displayed as the unique goal per branch
Current balance Yearly
Yearly is being duplicated because the yearly goal is on the row level when it should be at the branch level.
When i do group_average(yearly,branch) it displays
Is there a way to solve this? If I was unclear please let me know and I will make it clearer