cancel
Showing results for 
Search instead for 
Did you mean: 

The sum of 3 separate queries

Former Member
0 Kudos

We have developed 3 queries in on worksheet. Our users want us to create a summary total. Other than creating a formula is there any other way to do it.

Thanks

Accepted Solutions (1)

Accepted Solutions (1)

former_member188975
Active Contributor
0 Kudos

Hi Richard,

Instead of trying to doa lot of VB and formulas, may be you want to try to create a query definition that delivers the summarised data. What is your scenario like?

Former Member
0 Kudos

We have a query from the CCA cube. We have another from IO cube and another from WBS.

We are show a one line total for each but they are asking for a grand total at the bottom.

former_member188975
Active Contributor
0 Kudos

Wow..so in this case the way to do a "summary" query would be by creating a multiprovider..may be this is too much if the motivation is just a total on one workbook...

Former Member
0 Kudos

The multi-provider was our first thought but we could not come up with a column to link the 3 cubes.

Thanks for your help

Answers (1)

Answers (1)

GFV
Active Contributor
0 Kudos

Hi Richard,

if you are managing 3 different queries you cannot manage the result of these ...

A part from cretaing some Excel formulas the only solution is to define another Qury that integrates the logics of all your Queries to obtain a single result.

Hope it helps

GFV