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...
Hi I'm new here so sorry about the unconventional formatting. I have a item table with different coloured...
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...
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...
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...
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.
I want to be able to join 4 tables using a timekeeper ID as the bridge/commonality between all 4.
Multiple rows of Fees for each TK ID
Multiple rows of Costs for each TK ID
Status (Approved, Not Approved) - only 1 status for each TK ID
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...
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...
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...