I have a table that lets say shows salesmen, month, sales and reasons for sale. If sale has happened it is stated with 1 - if not it says 0.
Reasons are counted as these are stated with text. In the last colum I want to show the percentage of sales by dividing with reason, but I can't get this working. Either the result is 0%, 100% or even higher
In the Sales dimension there is a expression calculating sales for the selected month;
In the Reason dimension there is a expression counting reasons