Exploring, modeling, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

Table comparison - All Vs Selected

Reply
Occasional Contributor
Posts: 7

Table comparison - All Vs Selected

Is it possible to have a Table which will show All Values against Selected Values:

                       All Values            Selected Values

        2013           450                         234

        2014           634                         187

        2915           327                         116

 

Where the Column - All Values never changes and the Column Selected Values changes depending on selections from a Control Object.

SAS Super FREQ
Posts: 286

Re: Table comparison - All Vs Selected

Hello,

This is an interesting idea, but I think that filters and interactions will always act on the entire dataset used by a report object rather than a single variable.

You could create a table showing all values versus the selected values from an expression by creating a calculated data item. This would not be as interactive as what you are proposing where it is driven by selections in a control, however.

Maybe someone else will have some ideas?

Sam
Ask a Question
Discussion stats
  • 1 reply
  • 207 views
  • 0 likes
  • 2 in conversation