Merging Data Together doesn't work

[#1]

Hi.

I have two tables, one master - Incomes showing my incomes by id's (my sales by item),

and i want to be able to tell each Id it's expense.

Expenses are loaded from another table.

When I bring it all together,
Each Id has it's expense. great.

But, when i want to present in a pivot, all incomes and expenses,

Expesnes which has no Incomes in the other side but i can't.

Help...

See my project attached.

[#2]

Hi Gil, You have Synn Keys on your data model.

As per my understanding on your requirement, I modified the data model.

Please find the attached app.

[#3]

Hi.

Still as you can see, the sum of expenses in the original table sums to: 36,000

and in the pivot table it sums to: 33,000.

I would appriaciate if you can continue solving it out for me...

thank you.

[#4]

I entirely Modified the data Model and Please find the attached qvw.

[#5]

Hi dathu.

It took me time to learn your solution. It is great.

I have one last question.

When I add an expense to a car, that had no income at all,

for example add item 2014, 01, 300, 1000 (year,month,car,expense) to expenses.

It's missing in the pivot.

what do i do, for it to show?

Thank You, Gil.

[#6]

If you want Zero value if INCOME Missing, Goto to Presentation Tab and select 0 for Null Symbol & Missing Symbol.

[#7]

I Wasn't pointing there. I attached file.

As i said i added an item: 2014, 01, 300, 1000 (year,month,car,expense) to expenses

I want the pivot the present car 300, automatically with the new expense.

If I click populate missing values i get this:

[#8]

The file..

[#9 · Accepted solution]

Hi Gil, I added the new row to Expense Table in my qvw then I can able to see the data like below:

Please find the attached qvw as reference.

I am not sure where did u add the data.