Help with expression

[Anonymous]

I am using the following expression to create a table showing enrolments by region and year PLUS a Projection for 2016-17

Count({$<region=>} enrolments)
& Projection

However, the table does not show a SUM total for the Projection and when I tried to add a SUM element to the expression it also changed the values for the number of actual enrolments in a Year.

I used set analysis because I wanted the table to show all the regions regardless of a user selecting a region.  Instead, I have set up the table to highlight the selected region like below -

But the Projections for the regions not selected have disappeared.

Can someone help me with the expression?

Thanks

Greg

[tresesco]

Is it 'region' or 'Region' ? Field name is case sensitive here.  Count({$<Region=>} enrolments)

[Anonymous]

Try using

sum(Projections)

[Anonymous]

Or sum({<Region=>}[Projection]) to ignore the region selection

[Anonymous · Accepted solution]

Hi Greg,

Try RangeSum(Count({<region=>}enrolments),Sum(Projection))

Regards!!