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...