on 07-23-2014 10:00 AM
Hello,
I have some crosstab which data I use as a filter for other report components.
category | total spend |
---|---|
a | 1 |
b | 2 |
c | 3 |
total | 6 |
I am using following syntax to use category data as a filter:
DS_1.setFilter("category", CROSSTAB.getSelectedMember("category").internalKey);
I am wondering how to create the syntax to filter other report components by "total" from the crosstab (Enabling selection for totoals in crosstab)
As a workaround I am using button which clear the filters but it is not the same what customer required.
Any advice please ?
Hello Marcin,
When clicking total if you want to filter with all values of Category then you should pass blank value .
Please try following script.
DS_1.setFilter("category","");
Regards
Arjun KT
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Marcin,
If i understood correctly when you select total then you want to filter the DS1 data source with total.
Ie when clicking on total then all values should show in other data source??
if so then can you try following script
var v1= CROSSTAB_1.getSelectedMember("category").text;
if (v1== "total") {
DS_1.setFilter("category", "");
}
else {
DS_1.setFilter("category",v1);
}
Regards
Arjun KT
Hello Arjun,
your proposal is fine but the worst thing is that selection is not working when I am clicking on "total". For values "a", "b" and "c" is fine but for "total" it doesn't work.
Btw in propertis for crosstab option "Enable Selection" is true.
Total was created by choosing following display under Edit Initial View for Data Source.
Thanks.
Hello Marcin,
Am not sure whether you can make selection in the Total which is part of the cross tab.
So as a work around you can keep a button( with the name Total) in the place of total in the cross tab.
When user selects the Total button then you can filter DS1 data using blank.
DS_1.setFilter("category","");
The cross tab look and feel can be align properly with css i think . Just give a try if it works or not.
Best Regards
Arjun KT
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.