If I have a matrix visual where one column is a percentage of column total (where filters can change the output), how can I multiply that by another column within the matrix?
For example, if I’m multiplying the forecast error of an item (column in an existing table) by the percentage of sales dollars (which would appear as “%CT sales dollars)?
Edit: adding screenshots.
In the first screenshot you see that we have "products" and their sales dollars are marked as a percentage of the column total.
In the second screenshot, you see that the column still totals 100%, even if the matrix is filtered.
How do we create a third column that multiplies the two numeric columns together? IE- dollar percentage times forecast error percentage?
No comments:
Post a Comment