Grand total using Clustered chart with date as x-axis

[Anonymous]

Hello Community,

I´ve been trying to do the following bar chart and add at the end a grand total ("Acumulado"):

There is a work around by creating a new table and adding "Total" row (LINK). Then creating a measure but  it does not work with date column as it explained as follows:

Also, how to sort the x- axis by alphabetic order or an index since the sorting by column option does not work (error "column a cant be sort using column b")?

[Anonymous]

Thank you!

[lbendlin · Accepted solution]

Please don't do that.  Use a separate visual if you must, or use a different visual type (like a matrix visual) where you get the total for free.