Guages, Filtered and un filtered on same sheet

[#1]

I Would like to place pairs of guages on a sheet ie:
Guage1 = Sum(Sales Value)
Guage2 = sum(selected.Sales Value)

How is this acheived at the moment both guages update when a filter is applied ?

ColinR

[#2]

Hi Colin,

simply write:

Sum( {1} [Sales Values]) //Explanation: {1} stands for "selections are ignored"

Sum({$} [Sales Values]) //Explanation: {$} calculations are made only for selected values

See also QV help for more information on "Set Analysis".

Good luck!

Rainer

[#3 · Accepted solution]

Hi Colin,

simply write:

Sum( {1} [Sales Values]) //Explanation: {1} stands for "selections are ignored"

Sum({$} [Sales Values]) //Explanation: {$} calculations are made only for selected values

See also QV help for more information on "Set Analysis".

Good luck!

Rainer

[#4]

thanks, ive been wondering when set analysis should be used