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...
Hi,
Show the expected result on the dummy sales dataset that you have shared.
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.
