https://communities.sas.com/t5/SAS-Visual-Analytics/Table-comparison-All-Vs-Selected/m-p/247756#M3223 Hello,<BR /><BR />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.<BR /><BR />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.<BR /><BR />Maybe someone else will have some ideas?<BR /><BR />Sam Wed, 03 Feb 2016 14:41:00 GMT Sam_SAS 2016-02-03T14:41:00Z https://communities.sas.com/t5/SAS-Visual-Analytics/Table-comparison-All-Vs-Selected/m-p/247742#M3220 <P>Is it possible to have a Table which will show All Values against Selected Values:</P> <P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; All Values&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Selected Values</P> <P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2013&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 450&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 234</P> <P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2014&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 634&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 187</P> <P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2915&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 327&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 116</P> <P>&nbsp;</P> <P>Where the Column - All Values never changes and the Column Selected Values changes depending on selections from a Control Object.</P> Wed, 03 Feb 2016 14:01:53 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/Table-comparison-All-Vs-Selected/m-p/247742#M3220 BlueBrazil 2016-02-03T14:01:53Z https://communities.sas.com/t5/SAS-Visual-Analytics/Table-comparison-All-Vs-Selected/m-p/247756#M3223 Hello,<BR /><BR />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.<BR /><BR />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.<BR /><BR />Maybe someone else will have some ideas?<BR /><BR />Sam Wed, 03 Feb 2016 14:41:00 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/Table-comparison-All-Vs-Selected/m-p/247756#M3223 Sam_SAS 2016-02-03T14:41:00Z