Hi SAP community, i am new here and new to SAP BI Objects 4.2 , I am trying to create a formula in SAP that counts the entries that match my criteria. At the moment i am only able to do a single layer count. I have a file attached that shows what i am trying to do. I was advised to use Input control but that is not what i would like to do.
My database is basically about support tickets.
At the moment i am using the formula Count([Department];All) Where ([Department]="Customer Services"), this gives me the correct results of single criteria but i need based on 3 criteria. I actually would like to achieve below:
Goal 1: Count number of tickets under Customer Services that are about complaints and status pending.
Goal 2: Count average days pending under Customer Services and are about complaints.
Please help and thank you in advance.