relationships link tables

  1. K

    Excel Datamodel refers to orignal file data when saving as new file.

    My workbook contains 2 different tables of data (table1 andtable2) both data tables have a column named “Product” and from each data tableI have created a pivot table (pivottable1 and pivottable2) In order for me to be able to use one single slicer toselect/filter the same value in both pivot...
  2. A

    Excel Pivot Multiple Columns

    <tbody> ItemList Colour1 Colour2 Colour3 Colour4 Colour5 Colour6 Colour7 Colour8 Item 1 Blue Yellow Purple Green Orange Red Cyan White Item 2 Black Magenta Cyan Yellow </tbody> Hi I'm new here so sorry about the unconventional formatting. I have a item table with different coloured...
  3. B

    Multiple relationships between fact and calendar tables

    Hello, I have a Power Pivot model with one calendar table. I have 4 relationships between a fact table and the calendar table. I have about 50 measures. What I would like to accomplish is that these measures could be viewed in a pivot table based on different calendar dates. I know that I...
  4. I

    help with creating relationships, new to power pivot

    Hello Everyone, I am having trouble right now creating a relationship between two tables that I am trying to link. First, I would like to mention i'm using 2010 with version 2012 sp1 power pivot. what i am trying to create is two tables for based on nba teams and their respective...
  5. A

    Do relationships flow through in Powerpivot

    hi Folks Got a dilemma. I have a chart of accounts (LinkID) and 3 tables with YTD figures in them (linked together with matching linkID). I want to show Gross profit as a single entry under Cost of Goods sold instead of as another column. I am attempting to replicate David Churchward's rather...
  6. D

    PowerPivot: Subtract quantity only if date, period and price match between two tables

    Hi, I just installed powerpivot yesterday thinking that it might be able to solve a problem that I am facing. Also, I am not sure whether the task I am looking at doing is even achievable in powerpivot. I have two tables. Master and Sub. Both of which are hundreds of thousands of rows. The...
  7. P

    How to link 4 tables with ID number in each table

    Hello, I want to be able to join 4 tables using a timekeeper ID as the bridge/commonality between all 4. Table 1 TK ID Multiple rows of Fees for each TK ID Table 2 TK ID Multiple rows of Costs for each TK ID Table 3 TK ID Status (Approved, Not Approved) - only 1 status for each TK ID Table...
  8. D

    PowerPivot | Link two columns with similar values across two different data pulls

    I have two external data pulls currently coming into PowerPivot, one looks at actual hours and the other at forecasted hours. The two pulls are not identical, however they both include many of the same fields, including things like Project Name. I have it linked so I can pull several of the...
  9. M

    Help me create my First Tables and Relationship in Access

    i am preety new in Access but and i have some task to do which is preety simple, but hard to me - to create simple table here is the problem I have to create table with some fields for each month: Account (Text is format, but it is acctually number), Account_Name (Text), Amount (Number), Date...
  10. D

    Can't remove relationship??

    I'm wondering if someone can help me. I've created Access databases before, but my knowledge was a "know-only-what-I-need-to-know" basis. I'm now trying to re-learn it properly. My problem is I created 2 tables both with phone number fields. I then created a relationship between the two tables...

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top