How to change expression to get MAX ID PLEASE HELP!

[#1]

Hi,

I Have a expression as below in straight table.

Count(Distinct(ID)) & '    '& NUM(Count(Distinct(ID))/COUNT(TOTAL DISTINCT ID),'#,##0.00%')

Could anyone let me know how can I change the expression to get MAX ID.  I used below one

Count(Distinct MAX(ID)) & '    '& NUM(Count(Distinct MAX (ID))/COUNT(TOTAL DISTINCT MAX (ID),'#,##0.00%')

But this is showing 'Error in Expression'.

Thanks.

[#2]

Thanks and when I used this it is showing all values as 1-100%. Do I need to change anything other?

[#3]

I used Mandeep ones earlier but the fogures are showing entirely different when I compared with database values. Any help please.

[MK_QSL]

Please find enclosed file

[#5]

Thanks and actually in the excel file I have MAX PID. But in the database I don't have MAX PID directly.

so, when i select ID there are more than 10 PID under each ID. That is my problem . In this case how can i select to get the exact values whihc are in database.

[MK_QSL]

You can create below in script…

Load

Person,

Team,

Max(ID) as [Max PID]

Resident Data

Group By Person, Team;

and now use the file which i have given in previous reply.

[#7]

Thanks I tried but still it is showing the same incorrect values. I am totally confused . Is there any other way to sort this?

[#8]

Any Help please

[#9]

Hey Amelia,

It is my understanding that because of the table structure you have.... its not possible to get this report the way you want. Try converting your table into a cross table It will be easy to get it working.

[#10]

Hi,

Thanks. Could  please give me some points of how to convert to cross table?
I tried using cross table but it is not correct. could anyone help me please.

[#11]

Can anyone sort out this please?