Adding values from two different queries in one query

[Former Member]

Hi,

I have developed a web template by combining 3 queries ,which were created from the same MultiProvider.These queries are having many different selections .Now I need to get the addition of values from these 2 queries into third query.

Is there any way to combine the selections from these queries into one instead of recreating them again.I tried to use global strucuture but not successful.

Kindly let me know is there any workaround for this.

Thanks & Regards,

Raja

[Former Member]

Hi ,

You can do it by excel formula.

sheet 1 --> 1st query

sheet2 -->2nd query

sheet3--> put calculations accroding to your requirement based on sheet1 & sheet2 into sheet3.

Regards

Pcrao.