Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All,
Customer | Month | No.of Billing | Count |
A | Jan | 1 | 3 |
A | Feb | 1 | 3 |
A | March | 1 | 3 |
Customer and Month are dimension
No.of.Billing -> Measure(Count function is used)
Count column also measure -> How to achieve this???
Count column is calculated based on No.of.Billings we want to add
For every customer i want to calculate how many times they billed?
Hi,
Try to use this formula for the field Count:
Sum(Aggr(Count(Total Customer),Customer))
Jordy
Climber
Thanks for your response
If i used Total inside the count function it returns overall customer count to all customers.
For example my overall count customer is 500 means to all the customer it shows 500