I would like to add a total column to my bar chart. Not the total on top of each column that you can get by making it Stacked and toggling total labels. For example, if I have all the months in my bar chart i want an additional column that shows them all added together for a year total. Don't mind how bad my picture is 🙂
Would this work for you?
I created a table calc to total the values (TotalCalc). Then I created another table calc to show the total in the visualization at the bottom - the formula below checks which row the data is on and will show null for every row except the one with the highest row number:
if((row() < max(row())), null, ${totalcalc})