PowerPivot "Relationship Between tables may be needed"

Originally Posted by s_komail

Can you please make a manual sample , about what you want in result table and how it should look like. actually I'm unable to understand u completely

Hi ,
I actually provided a sample as reference and in reference i'v created a power pivot table .As you can see in screenshot SUM of ACTUAL hours Shows 174 in all rows and next to it (Right Column) which i manually created and highlighted with red color. This right column shows results which i want in that Sum of actual hours column..

MORE description with CASE
REG Table is Actually a Timesheet where developers log there daily (9 working hour) spend on single/different tickts .
IMP table is update only when new ticket come or when developer think estimation provided for ticket should be increase /decrease because of the new requirement come in between.

Case 1
Suppose Dev working on ticket no. 3456 for a month and log 5 hr daily in his timesheet(REG Table) he spending on 3456.
Dev provide estimation of 100 hr for 3456 in IMP table.
In Month end i will pick 3456 (or All tickets) from REG table(timesheet) sum up and compare with imp table ,what actual estimation he provided against his tickets.

Case 2
There are chances when multiple persons work on single tickets.

Sorry for writing too much . But i want to make sure you get a clear picture what problem im facing and help me out.
thank u..

Use IMP!Tickt no instead of REG!Tickt no as the row field item