I have some financial data but to show the values in a column chart, I have to make them "Sum of ....", so all my legends have Sum of at the start of them. If i use another measure, it values out at 1 for each month. How can I remove this so it is just LY Month, Budget Month etc..?
This is my visualisations field (Sum of Sort is my conditional column for ordering the months correctly):
This is my Query Editor (in case it is just a formatting problem) with some of the variables, thanks