Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi Greg,
Try RangeSum(Count({<region=>}enrolments),Sum(Projection))
Regards!!
Is it 'region' or 'Region' ? Field name is case sensitive here. Count({$<Region=>} enrolments)
Try using
sum(Projections)
Or sum({<Region=>}[Projection]) to ignore the region selection
Hi Greg,
Try RangeSum(Count({<region=>}enrolments),Sum(Projection))
Regards!!