Percentage based on another straight table column

[haymarketpaul]

I want to work out the percentage per brand in a straight table.  Not quite sure the best way to go about calculating the percentage column.  Any ideas most welcome.

Example

Last Page	Brand	Brand Count	Percentage
Basic	BR	10	6.25
Standard	BR	30	18.75
Bulletin	BR	120	75
Basic	CAM	65	19.12
Standard	CAM	250	73.53
Bulletin	CAM	25	7.35

[sunny_talwar]

May be this:

Count([Brand Count])/Count(TOTAL <Brand> [Brand Count])

[haymarketpaul]

Thanks for reply - that seems to make the %age column NULL ?

I've attached my qvw

[sunny_talwar · Accepted solution]

Try this expression:

=Count(UserID)/Count(TOTAL <Brand> UserID)

[haymarketpaul]

Perfect - Thank you