We help IT Professionals succeed at work.

Reporting Services Line Chart

ziwez0
ziwez0 asked
on
926 Views
Last Modified: 2008-01-09
Hi,

ive finally managed to create my huge SQL query to display on a line chart.

My chart displays to lines, example say SoldPrice and BuyPrice (x axis is month and y axis is price)  but how can I add a new line to show the difference between the two
say SUM(BuyPrice) / SUM(SellPrice) x 100

thanks
Comment
Watch Question

BI & Database Architect & Developer, Sitecore Developer
CERTIFIED EXPERT
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Commented:
Drag your tag, SUM(BuyPrice), onto the graph just like you did for other tags.  Right click and select properties, then edit the expression so you end up with SUM(BuyPrice) / SUM(SellPrice) x 100

-Frank
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.