Giving numbers a reference point

[#1]

I am building a dashboard where I want to show the average of a measure for the particular dimension I have selected on.  But I also want to put that number in context by showing it for the whole business so that a comparison can be made.  Is this possible.

To explain further, we have average premium by broker, and I want to pick one broker and show most of my dashboard relative to this broker, but also give them numbers some context by showing some figures across all brokers

[Oleg_Troyansky]

Something like this:

sum({$<Year=, Month=, Quarter=>} Sales

This set analysis condition ignores selections in fields Year, Month, and Quarter.

cheers,

Oleg Troyansky

Come and learn Set Analysis and Advanced Aggregation with me at www.masterssummit.com - take your QlikView skills to the next level!