Forum Discussion
Visual calculation - Subtract one value column with another
Hi, I would like a column in the matrix below to display the difference between the red and blue marked value columns. I want to subtract "Budget" with "Utfall" but it seems like visual calcula...
Hi Mjolnir for visual calculation, all input columns for your calculation should be add to your visual.
For part I can't find any function adding columns to the visual
Put columns which are your inputs columns in visual, then go to Home, select visual and in part "Calculation" name "New calculation" should be visible (beside New measure and Quick measure)
then go to this "New calculation" and in your window you will get
Calculation =
and type your columns with calculation logic (you can rename calculation)
Thank you guys!
I solved the issue creating new measures and added those to the column field and it did the job. Hope to see an easier way of doing this looking forward. I miss a lot of the simplicity found in excel in some cases.