I have 2 measures - Budget and Total Billing. I wish to compute the difference between these 2 columns.i.e Budget - SUM(Total Billing). However, when I try to create a calculated field, it says all fields must be aggregate or constant.
I am not sure how to go about this exactly. Any help would be great !
Can you wrap you budget in sum() as well? The sum will apply to whatever level of detail you have displayed, so a lot depends on how your sheet is set up visually. If this doesn't work, I'm not sure I understand the question. Can you post the packaged workbook file (twbx)?