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
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.
Thank you, Suraj! I solved things with a join.
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!
you should be able to do this with a calculated item in the joined query.
Solved it : not as hard as I first thought, but, again, not very easy either :). Thanks for the post anyway.