BookmarkSubscribeRSS Feed
Sam_SAS
SAS Employee

The total represents all of the values in the table. You cannot logically make a filter from that unless the table already being filtered by a control or by the drill-down state of the crosstab.

Pandu2
Obsidian | Level 7
Even the filters on the selected cell isn’t applied to the target page here. Not sure why
Sam_SAS
SAS Employee
It's hard to troubleshoot this without being able to see what you have.

Check the Actions pane for your Page 1 crosstab to make sure a page link is defined.

Is it possible that the target object uses a different data source / table? You would need to define mappings if that is the case.
Pandu2
Obsidian | Level 7
Nope, it is not. Infact, my whole report is controlled by a date slider
Sam_SAS
SAS Employee

You wouldn't see a filter based on the date slider because it affects the whole report already.

Pandu2
Obsidian | Level 7
Any other alternatives please?
Sam_SAS
SAS Employee

At this point I am just not sure we are understanding one another.

 

You might want to create a track with technical support so that you can show them what you're trying to do in a more private setting.

 

Or, you could create a mock report using fake data and share that with us. 

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

Tips for filtering data sources in SAS Visual Analytics

See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 21 replies
  • 3799 views
  • 0 likes
  • 3 in conversation