Hello, I have an issue with getting the percentages of some values not of the grand total but of column total given some data. In the axis I'm using "months", the legend is "type of sale" and I have two categories in that column (retail and fleets). In value I was using the sum of cuantity "QTY" , but of course I cannot get the % of the column total in the chart. I've been trying to create a measure to help me, I tried %column total= DIVIDE ( COUNT(Sheet3[TIPO DE VENTAS]), SUM(Sheet3[QTY])) but its not working. I would appreciate any help.
It should give me the values that are on the table on the left side. Thank you