How to display filtered pivot table when click on a text box object.

[jim_chan]

Hi guys,

I want to find out whether this requirement can be achieved or not. i have attached a sample.qvw file here.

1) i have a textbox with to state that - For Group A, there;s 3 record_ID. expression that i use for this text box is

=count({$<Group={'A'}>}Record_ID)

2) Now, i got the number already. So , i want to click on the textbox(with 3 records counted) , to  display out a pivot table.

3) this pivot table is a general pivot table, meaning just 1 pivot table.

4) So, when I click on textbox(shows 3 records) , the below pivot table with be filtered and only show Group A - 3 records details only.

Rgds,

Jim

[jonathandienst]

Add a Select in Field action (to select Group  = 'A' or 'B' respectively) and a Set Variable action to toggle a variable value. Finally, use the variable in the pivot table's conditional show expression.

You could dispense with the variable if a selection on Group is enough to control the visibility of the pivot. Use something like this in the Show condition:

     =GetSelectedCount(Group)

[tamilarasu · Accepted solution]

Jim,

Like attached.?

[jim_chan]

Thanks Jonathan!

[jim_chan]

Tamil ,

Yes it is. that's what i wanted to achieve! thanks!

Rgds,

Jim