Post reply

Creating an Aggregation within a Stacked Bar Chart??

  • May 18, 2011 at 11:07 am

    #239959

    I have a report that is using a Stacked Data Bar chart within a matrix, and the first value for the chart needs to be the First score by my students (First(Fields!Score.Value), and then the 2nd value is the following formula (Last(Fields!Score.Value) - First(Fields!Score.Value))...this basically is the growth of the student.

    When I attempt to do this I get the following error: 'The expression used for the calculated field '=Last(Fields!Score.Value) - First(Fields!Score.Value)' includes an aggregate....Aggregate functions cannot be used in calculated field expressions.'

    So I attempted to create a separate calculated field within my data set and then add that to the data bar...and I get the same error.

    Is there something I am doing wrong?...or is there a workaround?...I can not imagine this is not possible.

    Thanks!

  • June 16, 2011 at 1:37 pm

    #1340052

    The problem i believe you're running into is that it's a calculated field. You would be able to do your calculation in say a text box or something of that sort.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply