Does anyone know how to add custom forumal to calculated series on a chart?

OK I have managed to added the Average line. After much research I had to add Calculated series and select Mean from the drop down menu.

How ever my next task...

Thank you, but Im wanting the sum in the Query not in an Expression or calculated field, as the charts doesnt allow calculated fields as the data field.

I did try...

Yes I have, but this still gives me the average for each indvidual value rather than the whole value.

Thats is why I want to add a sum field in the...

Ive tried so many different things, but BIDS keeps erroring.

I have the average value as a text box on the matrix table. So I have tried as a data field...

Thanks but I already tried this and again it only work with one of the parameters, it doesnt take note of the other 2.

So I got it working with case...

ok ive managed to get this working with CASE statements, my only issue is I can not select multiple values. I used the statement below, then thought I need to...

For some reason, I found it was the second parameter that was slowing it down,

I deleted it and recreated it and now is working a treat!

The problem was with the data, there was " in the data which is why it was not exporting all data

I know very true, Its a request from the users, but I dont think it is good practice to go ahead with it.

But it would be interesting to know...

so the user has to enter the information twice??

Thanks, I already got that bit.

I mean the bit where you said "Then make the query for your report dataset dynamic based on the value selected"

I didnt understand what...

thank you. Getting there.

So I have added the parameter for search.

How to do assigned this in the query

Thank you for your reply.

so I need to help with this then if you could guide me. first of im not sure how to do a search selector??

Thanks

R

Thansk anyway

R:-D