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.
Yeah that I dont want. i want OPS Support as a % revenue to be shown seperately as a business line. In the Image Just imagine the two visual being one and OPS SUpport just being 6th Business Line.
Please send a mockup image of what you are trying to create.
Something like this.I think you could achieve this with a new table that sources data from your old tables, with three columns: Product type (AAA,BBB,CCC), Ops support (%), and manpower (%).
Alternatively, if you can create a relationship between your tables where AAA,BBB,CCC are the keys (so a relationship between the columns that have that data) then you may be able to just drag and drop ops support and manpower into the data field.
If you are still struggling, please send some anonymised sample data.