Analytics Workbook Calculated Measure % of grand total
Good day.
I am working on a transaction workbook for sales orders. I would like to get the % of the grand total for each row. I have searched and cannot find how to do this.
An example below, show sales by state with the % of the grand total.
State Sales Amount % of Grand Total
CA $400 40%
TX $400 40%
UT $200 20%
Grand Total $1,000 100%
Thanks.