Forum Discussion
Exclude members based on selected filters.
Hi Issue on Exclude members based on selected filters. Sample Data: Table Name:Sample ID Colour 1 RED 2 RED 3 WHITE 4 BLACK 5 6 WHITE 7 8 BLACK 9 ...
this will work (unless nothing is selected)
Total Count = calculate(COUNTROWS('Sample'),all('Sample'))- COUNTROWS('Sample') or simpler Total Count = COUNTROWS(all('Sample'))- COUNTROWS('Sample')
lbendlin
Super User
Super Userthis will work (unless nothing is selected)
Total Count = calculate(COUNTROWS('Sample'),all('Sample'))- COUNTROWS('Sample')
or simpler
Total Count = COUNTROWS(all('Sample'))- COUNTROWS('Sample')