Forum Discussion
Post PartisanTREATAS with 2 conditions same table
Hi,
The problem is in your time group columns. The values in the two tables don't match.
In Sales you have values:
Whereas in Budget you have:
So when treatas brings the filter over from Sales to budget nothing matches and you get a blank result.
Community Champion
I think it would be rare for any of us to do this for fun (except maybe for an interest we might have such as sports). The guys that work for me have instruction to look for as much help as they can get from people in this forum (including me, but they can always ask me at work) but to never, ever share confidential data because that's the kind of thing that gets people fired. So I completely understand. 🙂
Let me try to convince you of this: take 100 records from each of your Sales and Budget tables and drop them into Excel. Change details so you have family of "XYZ" or named after fruits (Apple, Banana, Orange, Mango, etc.) Change the amounts too if you like. Just include all columns from each table and I'll figure this out.
Community ChampionI want to add that with people in the forum who ask "this is what I want go make it for me" I'm a kind of an ass to, because it's clear they're not trying. You're different: you are trying! So I'm willing at help you as much as possible 🙂