Count values - grouping

Tomasz Dubiel January 15, 2018

Hello.

I want to make a report which counts number of issues groupped by two columns (let's say colA and colB), but the problem is that I don't want single value grouping, but for example:
first row: number of issues where colA in ("A", "B"), number of issues where colB in ("C","D")
second row: number of issues where colA in ("E","F","G"), number of issues where colB in ("Y","Z").

I can do it without grouping, just using filters, but when I want to add second column with other values in filter, nothing is returned as conditions are in conflict.

Is there any possibility to achieve this? 

0 answers

Suggest an answer

Log in or Sign up to answer