I have two table, one consist of Table 1 Policy ID, Region, Total Policy, Rework count etc (Policy ID in this table will not be duplicate), Table 2 consists of Policy ID, Rework Reasons, Sub-Rework Reasons 1 (drill down from Rework Reasons), Sub-Rework Reasons 2 ( drill down from Sub-Rework Reasons 1) (this table will consists of duplicates as a policy could be rework multiples time) The challenging part is that how to joint the tables to enable to get the best analysis which country having the most rework and the relationship between parties. Currently the tables i have created, it is way to unmanageable to let me pinpoint where are the issues. Appreciate anyone could share some ideas.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
Help!! using two tables in Power Pivot to analyzing rework
- Thread starter Sian1
- Start date
Excel Facts
Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).
Similar threads
- Replies
- 4
- Views
- 512
- Replies
- 5
- Views
- 442
- Replies
- 3
- Views
- 1K
- Question
- Replies
- 2
- Views
- 743
- Replies
- 0
- Views
- 503
