Hi,
I have a little problem calculating a simple difference in a group.
For example:
I have a group YEAR with values like 2010 or 2011 and I have a table SALES where all my sales are in it, for 2010 and 2011.
I want to calculate the sum of sales for 2010 - the sum of sales for 2011. And want to show it for all hierarchies like quarters or months. And than want to be able to use it in a chart too.
In Web Intelligence It's very simple to calculate, because I can filter my data in a formular with the WHERE operator. Is there anything like this in Crystal Reports? I tried running sums or to filter my data with IF and ELSE but nothing could help me...
I hope the problem is understandable...