% of column

[#1]

Hello

i am writung a report and have built the following table

Company Service used Count of service used

Where Company and service used are dimensions and count of service used is an expression.

I simply want the count of the services to reflect the % of the overall amount of services used by the company, is this possible?

Jon

[sparur]

hello Jon,

Yes it possible:

count([Service used]) / count(TOTAL <Company> [Service used])

[sparur]

hello Jon,

Yes it possible:

count([Service used]) / count(TOTAL <Company> [Service used])