Forum Discussion
Measure Calculation
Hello, I am trying to calculate the percentage of total sales of a particular product through different puchasing avenues, and different locations for each month. I have a table that is set up fo...
Ashish_Mathur The expected result with the dummy data for Product A1 would be:
| Avenue | Location | Amount | Total Amount | % of Total |
| Online | Location A | $500 | $500 | 100% |
| Location B | $0 | $500 | 0% | |
| In-Store | Location A | $325 | $325 | 100% |
| Location B | $0 | $325 | 0% | |
| TOTAL | $825 | $825 | 100% |
Note that this visual is a matrix, which is why the second value for each avenue is empty. Also note that the Avenue and Location come from the first table of all possible combinations, otherwise the combinations that yield $0 will not show, such as the combination of Online and Location B.
