Hi All!
I'm a bit new to this, so any help would be highly appreciated!
I have a Few Tables, Mainly the "Highlighted below" are my 2 (soon to be 3) primary data tables,
Harvest TIME has "time" expenses, Harvest Expense the "Software" Expenses (and dates of the expenses), and later i will be adding "Income", so what I want to do is be able to get, Time Expense - Software Expense (as they are both Negative Values) + Income. but allocated to the correct client in my Pivot to give me a total profit or loss that i can use on my Main Pivot / In charts later,
Im familiar with sumifs but this doesn't translate (or I'm doing it wrong!) when trying to create a custom measure, I've go a relationship between the two current expense tables (if that helps)
Many Many thanks for your help in advance! I will be adding Income soon, but wanted to see if it is doable before going forward!
PS sorry if it looks a bit messy, I'm new to this world, but definitely enjoying it!
Sio
I'm a bit new to this, so any help would be highly appreciated!
I have a Few Tables, Mainly the "Highlighted below" are my 2 (soon to be 3) primary data tables,
Harvest TIME has "time" expenses, Harvest Expense the "Software" Expenses (and dates of the expenses), and later i will be adding "Income", so what I want to do is be able to get, Time Expense - Software Expense (as they are both Negative Values) + Income. but allocated to the correct client in my Pivot to give me a total profit or loss that i can use on my Main Pivot / In charts later,
Im familiar with sumifs but this doesn't translate (or I'm doing it wrong!) when trying to create a custom measure, I've go a relationship between the two current expense tables (if that helps)
Many Many thanks for your help in advance! I will be adding Income soon, but wanted to see if it is doable before going forward!
PS sorry if it looks a bit messy, I'm new to this world, but definitely enjoying it!
Sio
