This content has been marked as final.
Show 3 replies
-
1. Re: Filtering out Nulls across multiple data points
Stephen Rizzo Jul 15, 2016 12:44 PM (in response to Courtney Young)You should be able to use a table calculation to calculate the number of events an ID is associated with, then filter on that variable. See attached. Is this what you were looking for?
-
SampleWkbk_CBY.twbx 316.7 KB
-
-
2. Re: Filtering out Nulls across multiple data points
Courtney Young Jul 15, 2016 1:02 PM (in response to Stephen Rizzo)Hi Stephen,
I think this will give what I need - THANK YOU!! One follow up question, if you don't mind. Is there a way to bring back in the Grand Total? It's just showing as a blank now. Is there a calculation I can add for that? (please forgive my lack of knowledge when it comes to calculated fields).
Thanks again for your help!
-
3. Re: Filtering out Nulls across multiple data points
Stephen Rizzo Jul 15, 2016 1:09 PM (in response to Courtney Young)Glad to help! The column grand totals don't appear blank for me. Maybe try disabling them and turning them back on? You can change which totals are displayed in the Analysis > Totals menu.