I need you help for this.
I have a transaction table with4 columns
From these datas , I would want to create a new summary table by Number of transaction
- Number of transaction (1 , 2 , 3 , ...) ; count of clients ; total amount
For example, I want to know, how many single client (who bougth one time), ...
I would want to know if I can build my table without using the script (with simple table) or i need to aggregate datas on the script ?
Thanks for your help
For a unique transaction-number you should hardcode this in the script. Other calculations can be done in simple table/graphs, just with your required aggregation as Expression and required dimension. In the first approach think that this should do - you may then go lateron into more sophisticated formulas.