- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Individual table for values in an existing table
I have a table that has 20 items that show the variance between the estimate and actual cost of a project. Each item has it's own table that breaks down the costs for each project resulting in 20 individual tables. How can i go about dynamically switching between the 20 individual tables?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
This is the Main Table. Each "WR Number" has it's own table breaking down the costs.
Table below is an example of what each individual table looks like.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Your main table should only holds the below.(As a Dimension)
WR Number,WR Required start Date,WR Firld Complete date, WR Work Category
You should also populte WR Number(If not already) for each of the other tables and merge them into a single fact table. Create an index if necessary.
Define a relationship between the two based on WR Number.(1 to Many)
All the other columns such as WR Est Loaded Cost,Actual Loaded Cost, Loaded Cost Variance should be measure if you have the underlying data and calculations to populate them from fact table. Otherwise it doesn't hurt to keep them in dimension.
Please post if you have any questions. Sample data is better than a picture of sample data for us to work with.
If this helps, mark it as a solution.
Kudos are nice too.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
08-02-2024 11:49 AM | |||
02-08-2023 02:37 PM | |||
07-03-2024 08:57 AM | |||
06-14-2024 04:14 AM | |||
06-26-2024 08:07 PM |
User | Count |
---|---|
141 | |
115 | |
84 | |
63 | |
48 |