'total' calcualtion and overcoming affect of filters
Hi,
On the attached app please see table entitled 'Rating breakdown by Reporting Unit'.
The calculation I want to happen is rating (i.e delivered, excelled or inspirational' / total for each rating. So in the example of delivered the calcualtion we requrie is 18/29 in 'delivered %' column, 11/29 in the excelled % column etc. I need this to work without clicking additonal filters that would restrcit the data to one area (e.g Eccles) being shown.
The current expression whilst it works when I pick one criteria, e.g Eccles doesn't work as a table as a whole. As we need to compare all areas in one view the expression we require is imperative.
That seems to work. To calrify how have you done that..have you made changes to an expression or is an unticked box I have missed? Its seems its the inclusion of <Area>..am I right?
that's right yes, I've added the Area dimension to your total. What that means is rather than giving you the overall total of Rating, this will now be split by the dimension specified.
Great..one last question. Will this expression work if I make the table a 'cyclic' group or would I need to craete a table each dimension (e.g area, town, neighbourhood) and update expression accordingly?
If you use a cyclic group rather than a single dimension, then you'd need to include all the possible dimensions in the expression too, apart from that it should work yes
