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.

Rookie Asked on January 29, 2023 in How To's.
Add Comment
0 Answer(s)

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.
  • This site made possible by our sponsors:   Tipalti   Celigo   Limebox   Become a Sponsor   Become a Sponsor