Skip to Content
0
Former Member
Jul 10, 2008 at 07:22 AM

Crosstab Highlight & Filtering Problem

45 Views

Now, i'm creating a crosstab report of user activity trend in the system usage

crosstab is already produce by

row: user

column: activity

summarized field: count of activity (grand total)

the simple structure likes that:

action 1 action 2 action 3 grand total

user 1 x x x x

user 2 x x x x

user 3 x x x x

And now I want to make certain condition:

- Highlight the top 5 records and

- Filter out the user which is below 30 activities

Have any formula to perform this two condition,

as I know there are TopN function in group sort expert but not highlight expert,

and select expert doesn't control the summarized field to let me using "greater than" function

looking for the solution...

thank...