Pie chart from 2 queries

[iulian.bobalca]

Hi!

I have a report that looks like this (two different queries with 2 totals):

Q1             Q2
total1         total2

How can I represent as a pie chart their proportions ( total1=100% , total2 = ? )

Thanks

[Suraj]

Create another query that joins those two and use that to generate pie chart.
without a join or union you can not bring those together.

[iulian.bobalca]

Thank you, Suraj! I solved things with a join.

[iulian.bobalca]

Hello again!

Actuallly I have another problem with summaries (as you see, I'm not the sharpest tool in the box with ReportNet): what if total2 is a count distinct and I want to make a calculation based on those two summaries

Q1             Q2              Calc
total1         total2          calcVal
(total)        (count dist)  (total1/total2)


Thank you!

[Suraj]

you should be able to do this with a calculated item in the joined query.

[iulian.bobalca]

Solved it : not as hard as I first thought, but, again, not very easy either :).  Thanks for the post anyway.