Display static result based on dynamic data

Question

I am not sure if the subject make sense but here is what I am trying to accomplished.

I created an analysis showing ranking data for example

NameSales %RankingJohn90%1Peter80%2Joe70%3

But then I want when Joe logs in and run this analysis to see ONLY his record and see that he is #3

Or create another analysis that can be based on this but again to show only the log in user record and no one else but then show his record based on everyone else, in this case Joe would be # 3, Peter # 2 etc

Thanks

Joe

Thomas Dodds · Answer

If you had a snapshot of the rankings at regular intervals it would be a simple case of row-level filtering and not having to worry about a dynamic ranking.  To boot, you'd get the ability to show snapshot-over-snapshot increase/decrease in the rankings ...

Sherry George · Answer

Just taking a stab at this. You could create a session variable first  to capture the user login. Then create a union report and choose 'intersect' as the set operation. Both reports are same except for, in the first report for the 'Sales%' measure use the 'filter using dim' option and filter the 'Sales%' measure using the User dimension (value captured by session variable). This hopefully does it.

Sorry if it is a dumb idea.