Hi. I have this problem
Group by will make the table only show a value of that group once.
So lets say there was 1000 results without group by.
500 with a single group by.
But now i want to do another group by to filter it down more to like 250 results
However if you try to do group by group1,group2 it ends up with more results like 700 because it group1 and group2 together is now a unique trigger not filter by one and filter by the other.
So anyway to do something like this?