Forum Discussion
How to do a count of count without aggregation
The method I propose is dynamic and will work with any filters, slicers etc. The only static thing is the generated table for the numbers of orders, but as long as you create that to far exceed the possible number of orders then it shouldn't be a problem.
Hi Jonht75,
Thank you very much for your answer, that works nicely.
Initialy, i wanted to generate automatically the table below :
| Number of customers | Number of orders |
| 2 | 1 |
| 1 | 2 |
| 1 | 4 |
Do you think it is possible ?
johnt75Super User
That's the table which is generated as the GroupedTable variable in my code, but I don't see a way to get that into a table in a report.
Yes, that's my problem since the beginning. The request looks simple but it is not...
I was able to acheive this with calculated table, but it's generating a static table that will not work with filters in the document.
Thanks for you help anyway.
- johnt75
The method I propose is dynamic and will work with any filters, slicers etc. The only static thing is the generated table for the numbers of orders, but as long as you create that to far exceed the possible number of orders then it shouldn't be a problem.