Hello,
I'm trying to do a Project Summary Report. My sample data is below.
ProjectRef | ProjectDesc | Customer | Value | Hours |
101 | Build A House | Customer1 | 1000 | 10 |
101 | Build A House | Customer2 | 2000 | 12 |
102 | Dig A Hole | Customer3 | 1500 | 5 |
The report I'm trying to is below. I want one line per Project, and where there are multiple customers I want it to say 'Multiple' in the Customer column as an example below. I've tried a calculated dimension with this expression but to no avail as yet.
=if(aggr(count(Customer),ProjectRef,Customer)<=1, Customer,'Multiple')
ProjectRef | ProjectDesc | Customer | Value | Hours |
101 | Build A House | <Mulitple> | 3000 | 22 |
102 | Dig A Hole | Customer3 | 1500 | 5 |
