Rolled up numbers in a table and filtering

[#1]

Hi,

I have requirement where I have data like below:

Name	Test1	Test2	Test3
ABC	On site	Off site	Both
XYZ	Off site	Both	On site
DEF	On site	Off site	On site
PQR	On site	Both	Off site

and I have to create a chart that shows the rolled up numbers like

	Test1	Test2	Test3
On site	3	0	2
Off site	1	2	1
Both	0	2	1

I was able to create similar looking chart using ValueList but the problem is I am not able to filter by selecting the values within the table.

The requirement is the user should be able to click on the values within the table and filter should be applied accordingly. For example, if the user clicks on value 3 in the above table, the filter should be applied on name field. In this case, Name should be filtered as ABC, DEF & PQR because these are the three names that has On Site value associated to Test1.

Attaching a sample qvw. Please let me know if something is not clear. Any help on this would be greatly appreciated.

Thanks!

[robert_mika]

This may not solved all your problems but try:

Change to Pivot table

Add Name dimension to the right of the Valuelist.

You can filter down when you expand the second dimension

[Anonymous · Accepted solution]

If you use crosstable in the load script, the solution on the front end is trivial.  See attached.

[#4]

Hi Michael,

I was able to change my data model with crosstable for this data and was able to achieve it. Thanks a lot for your help.

Thanks,

Malai

[#5]

Robert - It was helpful. If there were no other option I would have gone with this but Michael's suggestion below worked to satisfy my requirement completely. Greatly appreciate your help on this.

Thanks,

Malai