Forum Discussion
kg4u
Helper II
3 years agoHow to divide column totals
Hi, I have looked through this forum and searched online but cannot find a solution for what I think is an easy problem. Below is my data table, and I simply would like a measure that will calcu...
kg4u
Helper II
3 years agojustingraff88 Not quite what I am looking for. I want to divide the column totals (5,161.3/4392.7)
justingraff88
Helper I
3 years agoIt will display at the level it is at. So the total (117.50%) is the total of the columns divded by each other. If you don't want to display it with the different product levels showing I would recommend just putting the measure into a card visual (this would be the easiest way).
Alternatively you could just change the text and background of that column in the table to essentially hide the values