Pivot tables

[#1]

I have a table with username, time, frequency of queries run by that user.

Now, when i click on frequency, i want all the queries to be displayed.

How can i do this? Is pivot table the correct approach?

Thanks!

[Anonymous]

It's not quite clear what you mean here. Please ellaborate on the question

[#3]

So i already have a table with 2 columns containing the user name and the frequency (of times the user has run a query).

Now i want to add another column to the table. This column should drill into the frequency and show all the individual queries run.

So for example, if someone has a frequncy of 10, then if we drill down into tht frequency, it should show 10 different queries.

[#4 · Accepted solution]

If you use a pivot table you could have the querries in a collapsed dimension so you would either be able to see all of them or a summary.

[#5]

yeah thts right, but how do i add the 10 queries? it doesnt seem to work in a pivot table.. or im doing something wrong.

[#6]

OK i just got it! I was implementing it wrong!

thank you for all the help!