Sum(Count)

[#1]

Hi

I have a document that has two dimensions in the following order

Owner

View

The view is text and has 4 alternatives so I do not have difficulty with the count.

However I would like to work out the percentage of the views .

the simple formula would be Count(View)/Sum(Count(View)) for each owner.

Could someone please assist.

Regards

[miguelbraga]

Hey there,

Can you please post a sample data or a qvw so we can understand better your problem? It's unclear what you're trying to achieve.

Best regards,

D.A. MB

[trdandamudi]

May be as below:

Count(View) / Count(Total  View)

[sunny_talwar]

Or may be this:

Count(View)/Count(TOTAL <Owner> View)