I need an aggregation that excludes the value of the last grade level for each school (as shown in the red square)
The value is in reference to attending students, I need to sum all the attending but exclude those in the last grade of each school.
Thank you!
Hi Diogo,
Please Check screenshot and attached. It looks you have some data in case of CABA, so it is not going away.
Thanks
Deepak
Thank you! Why CABA is not going away?!
It shows maximum month as 11 but there is no data ..please check the sheet where i did some monthly analysis
Yes, it's fine. Your solution works! Thank you!
Now I need to reverse the logic.
I need to show all the schools and grades that was excluded from this calculation. Let me know if I should start a new discussion.
Hi Diogo,
Check Screenshot and attached.
Thanks
Deepak
In the Calculation 1 instead of <> used earlier, now use =
I Corrected it. Just filtered out Null Values in Context Filter and then CABA and others are working. See attached for both cases.
Thanks
Deepak
For Reverse Logic. You will See that values for CABA and Clay which are 9 and 54 now showing. Again moved 16-17 to context and selected non null from Special values.
Thanks
Deepak
Thank you so much for you help!