Set Analysis in Straight Chart

[#1]

Hello,

Can you use the result of a separate object in set analysis for a straight table ?

I want to show the attendees at various seminars as a percentage of total staff. I have the 'Course Name' as the dimension in the straight table and can calculate the count of attendees no problems. I have used the following set analysis for the percentage calc:

=NUM(count({<ATTENDANCE = {'Compulsory'} >} [EMP NO.]) /

count({<[ACT/INACT] = {'A'}>} [EMP NO.]),

'#,##0.0%')

I get a 100% for all courses as I think it is calculating based on the dimension of course name.

How do I get it calculate on total staff, which I have as a separate text object with the following expression (same as in above set analysis):

count({<[ACT/INACT] = {'A'}>} [EMP NO.])

Thanks

Wayne

[SunilChauhan]

NUM(count( {<ATTENDANCE = {'Compulsory'} >} total [EMP NO.]) /

count({<[ACT/INACT] = {'A'}>}  total [EMP NO.]),

'#,##0.0%')

[PrashantSangle · Accepted solution]

Hi,

Try with TOTAL keyword Like this,

NUM(

count({<ATTENDANCE = {'Compulsory'} >} [EMP NO.])

/

count({<[ACT/INACT] = {'A'}>}  TOTAL  [EMP NO.]),

'#,##0.0%')

Regards,

[#4]

Thanks Max,

Simple as that.