Excel joining 2 Olap Pivot tables together

Dear all
I created my Cube using SQL Server 2012.
I want to create my dashboard using Excel 2013.
The idea is I have two pivot tables that I want to link together.
How can I do that?
Later I will create my chart on this new pivot table that contains both Pivot tables.

Thanks,
RamzyNEbeidAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

RamzyNEbeidAuthor Commented:
like vlookup in excel.
0
RamzyNEbeidAuthor Commented:
i tried this in the calculated member of the olap Pivot table

VLOOKUP(B4,A120:B128,2,FALSE)

and this was the result = there was a problem creating the calculation exception from result = 0x800A03EC.

thanks,
0
RamzyNEbeidAuthor Commented:
please i need help.

thanks,
0
Protecting & Securing Your Critical Data

Considering 93 percent of companies file for bankruptcy within 12 months of a disaster that blocked access to their data for 10 days or more, planning for the worst is just smart business. Learn how Acronis Backup integrates security at every stage

Zack BarresseCEOCommented:
Hi there,

What version of Excel are you running? If you have ProPlus or Professional Plus you can get Power Pivot and use that. In any case you'll need to relate the data somehow. It sounds like you have a single data source but two distinct PivotTables from that one source? Your best bet would be to have this field already in your cube. If you used Power Pivot you would create a measure for this (or, as an alternative, a calculated column). Although without knowing more there's little we can do to help you. Do you have a sample file you could attach? Or describe, in detail, what it is you're trying to achieve?

Regards,
Zack Barresse
0
RamzyNEbeidAuthor Commented:
i use Excel 2013.

the idea is that i want to make a relation between the tables.

the 2 tables are pivot tables and are from the same CUBE.

if you see the first table you will find column named: "vlookup" i want to replace this column with the value: 4572010 because the Month of the first table = Month of the second table.

please let me know if you need more calcification.

thanks,
excel.jpg
0
Zack BarresseCEOCommented:
Assuming you have Power Pivot, load the PivotTable data caches into the data model (i.e. Power Pivot), relate the tables, bring in the other field as desired. If you don't have Power Pivot then you'll either need to join the data prior to returning from SQL Server to get your values that way, or you'll need code to dynamically clear/enter formulas to retrieve data.

So what version of Office do you have? Is it ProPlus, Professional Plus, or standalone Excel? If not, do you have access to one of those versions? It can be built by one of those versions and consumed by all versions of Excel [2013].

Zack
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.