Forum Discussion
Help with Calculations.
1. Putting % in column does not help as when you drag these columns in your visual as values it either sum, average, max, min, and etc them. you wont be able to take 1 single value that you want. There is no measure which support % value only way to get % with right value is to have base data and calculate it through them.
2. Putting 2 measure or column as values in a visual will create that many column for each category.
I found a temorary solution to add another line for revenue in my excel files. With Name Ops Support so now my visual is working.
1. Putting % in column does not help as when you drag these columns in your visual as values it either sum, average, max, min, and etc them. you wont be able to take 1 single value that you want. There is no measure which support % value only way to get % with right value is to have base data and calculate it through them.
2. Putting 2 measure or column as values in a visual will create that many column for each category.
I found a temorary solution to add another line for revenue in my excel files. With Name Ops Support so now my visual is working.