How to remove duplicate data in same column?

i have column named ‘Month’, as below:

Month Income
Oct 2022 15.50$
Oct 2022 80.00$
Oct 2022 45.60$
Oct 2022 125.50$
Nov 2022 75.90$
Nov 2022 0.00$

i want to remove duplicate of the month and get the Sum of every month. like example:

Month Total Income
Oct 2022 266.60$
Nov 2022 75.90$

  • create a multiple relation column that matches the month column to itself.
  • do a rollup->sum through that relation
2 Likes