Table comparison - All Vs Selected

[BlueBrazil]

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.

[Sam_SAS]

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