Straight Table in Qliksense

[marishnagendran]

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?

[JordyWegman]

Hi,

Try to use this formula for the field Count:

Sum(Aggr(Count(Total Customer),Customer))

Jordy

Climber

[marishnagendran]

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