Hi,
I requiring a way to group the number of companies by week so that any number = 1 interaction for that week ....
see
| Row Labels | Count of adnumbr |
| ABBEY ROAD CAR SALES | |
| 14 | £1 |
| 41 | £1 |
| 43 | £1 |
| 45 | £1 |
| andy briggs | £1 |
| AUTO IMAGE CARS LTD | £33 |
| CARAT - A TRADING DIVISION OF AEGIS MEDIA | £7 |
| CJS CAR SALES | |
| 43 | £1 |
| DSG GROUP LIMITED | £3 |
| EMLYN STREET TYRES | £1 |
| ENVIROCASTING LTD | £12 |
| HANDMARK ENGINEERING | |
| 6 | £2 |
| LONGLANE GARAGE | £5 |
For handmark engineering in week six it counts it as two becasue there are two seperate ad numbers in the transaction table.
The week is in the calendar table and it is joined by the date in the transaction table. I need to somehow identify that there is only one interaction for that week... Any ideas?
Calendar table
Date | Finweek | Week of Year| Month Year
Transaction table
Date | Company Name | Title | Sale Price
