I'm working on a report to get a projection for some data, I need to add some data to the chart which is a matter of drag and drop for any data field in the existing dataset, but what about a calculated field?? how can I do it?
when I try to add a calculated field to the dataset, it gives error "The expression used for the calculated field '=Sum(Fields!Total2010.Value)/DateDiff("d", "01/01/2010", Parameters!Day.Value)*365' includes an aggregate function. Aggregate functions cannot be used in calculated field expressions"
and I can't find a way of adding it directly to the chart
any help will be appreciated please.