Hi there,
WE have a list report with 5 columns:
ColA, ColB, ColC, ColD, ColE
- Grouped on ColA
- ColE = days_between ( [Order Created], [Package Created] ))
QUESTION :
- We now need to display on another report (same or different page) to count the "number of times" all equal "ColE" values appear for each ColA value.
- For example: We want to know how many times does the value 1 is displayed on the report for each ColA. How many times does the value 2 is displayed, etc up until value 4.
ColA, NbTimesValue1, NbTimesValue2, NbTimesValue3, NbTimesValue4
regards.
count(distinct [ColB] for [ColA])