Filtered CUBESET from related tables

Use this forum for any general discussion and questions about Excel
murphys
Posts: 1
Joined: Fri Mar 20, 2020 1:47 am

Filtered CUBESET from related tables

Postby murphys » Fri Mar 20, 2020 2:21 am

Hi,

First question here ! So thank you in advance for your answer !
Hopefully I can get help !

My goal is to obtain a filtered CUBESET containing all the ContractName based on the ScenarioNum.

[attachment=0]Capture.PNG[/attachment]

Here's how to understand the structure :

I have a table Contracts containing all general information on my contracts.
I have a table ContractsByYear containing specific information by year for each contracts
I have a table Scenarios containing multiple scenarios about which contracts I should consider
I have a table ContractsByScenario that specify wich contract is in a specific scenario

So now, my goal, as I said before is to obtain a CUBESET containing all ContractName filtered with a specific ScenarioNum.

I can't figure how I can obtain that.

Somebody knows ?

If you guys need more details, feel free to ask !
Thanks !
Attachments
Capture.PNG
Capture.PNG (6.41 KiB) Viewed 1618 times

Return to “Excel”

Who is online

Users browsing this forum: No registered users and 2 guests