I have a straight table that shows the number of orders broken down by order sources. How can I create another measure that shows the breakdown percentage of the total by dimension. For example, if the total number of orders is 36,035 that total is 100% for the month. How can I calculate the % breakdown of that 100% by dimension in a corresponding column?
See below example. I added the 100% for illustrative purposes.