1 of 1 people found this helpful
I don't know about your data set. If these are two different dimension then you can create a calculated field as revenue-expense.
If possible, please share sample workbook or data set to help you better
Thank you for your response. Unfortunately my Revenue and Expenses are only under one dimension. I made a sample workbook to show this but I'm still trying to figure out how to attach it here. How do I share the file here?
Thanks in advance for your help,
My data set is similar to the snapshot you show above. I created the two calculated fields for Revenue and Expenses and then created an additional calculated field for Revenue - Expenses and used this field to replace my current "cost" Measure in the dashboard. That solved my issue. Thank you!
As I noted above, I cannot figure out how to share/attach a sample data set. How do I do this? I'm sure it is easy but I don't see any "attachment" icon to attach and upload sample files.
Thanks again for your help!! Very appreciated.
Good job solving it.
Clicking reply you should see "Advanced Editor and add an attachment"
Click that changes the page and the attach appears bottom right.