That would be the best solution. Solve the grouping within the SQL Query that you use as a source for the report.

Don't forget to exclude (subtract) the last week's...

Create a group with an Expression for Grouping. Use something in the lines of

iif(Cat="CatA" or Cat="CatB", "Group1","Group2")

Create totals for your groups.

That will however add a Total for Group2 as...

I don't know, I'm sorry. But do you expect the user to scroll down to number 614275?

I'm sure the limit is high enough not to hinder the user experience...

Could you enlighten me on the added value of such a ticker to your report?

In the nineties all websites were flooded with those horrible flashing text boxes since it...

I'm not sure but can't you use a custom made render option in your subscription?

First create one[/url]. Then see if you can find it in your schedule options.

Although you've figured out the right command, your results won't be as expected.

It will never turn yellow when Fields!PctComplete.Value = 1 but it'll be blue 🙂

You could just make the cubes unavailable perhaps? As a measure of last resort if noone else comes up with a better solution...

Just do an unprocess or a process of...

why would you want to let them enter it manually instead of providing all valid options in a dropdown box?

That's so error-prone... People will call you every hour telling you...

I've stated not the Axis properties... Keep your axis as is.

I'm borrowing this image from MS. You should right click 'FullName' and choose Group Properties. And go from there to...

I have it working with my reports. Did you create a new chart?

did that work?

why would you want to associate 1 with April and not January? :unsure:²

anyway, it's an evil solution :sick:, if you really want to hard code, do it in SQL.

but let's...

I think you've already helped abundantly 🙂

are you saying aliasing with T1 and T2 is a bad habit?

basic math tells me both our equations are the same

Nice job there 🙂 You should indeed fill the "divide by zero" black hole.

But the change % formula is strictly seen incorrect 🙂

T2.[Total Mins]/T1.[Total Mins] - 1 should do...