Should your Output have Alex = 2?

Typo it should be 9 in Red 6 in AMber/Orange and 3 in green

Sure . So I have this column called Device color and say this is the data

DeviceColor

Red

Red

Red

Red

Red

Red

Red

Red

Red

Amber

Amber

Amber

Amber

Amber

Amber

Green

Green

Green

So the expression

COUNT(Fields!deviceColor.Value) &"(" & SUM(IIF(Fields!deviceColor.Value = "Red",1,0)) & " " &...

https://social.msdn.microsoft.com/forums/sqlserver/en-US/33210df6-15df-4b00-a7f2-e6f12eb1d649/ssrs-stacked-column-chart-with-two-value-series

this helped

Thanks:)

Oh yes! Thanks

That really helped. Thanks

That's helps. Thanks

3 columns 1 row

I want to see output as

Excel Dave,Ken 15

That helps. Thanks

Came up with two separate queries one for last week and one for alternate weeks (%2) and did a Union. That helped

Glad I found this helpful link ... http://stackoverflow.com/questions/20469258/formatting-fields-to-show-currency-in-ssrs

Oh Ok. Thanks again

Did that help.

If multiple tablix try checking the datasource option : SUse Single transaction when processing the queries.