Bench marking?

[#1]

Hey I want to know how I can keep one value (Name) from a field and show the comparisons to other values without showing the one that is selected and if possible how I can make these selections using an input box as that has left me confused.

Thanks  for any help in advance.

ಸ‿ಸ

[sunny_talwar]

Not sure I completely understand, can you may be elaborate?

[#3]

Well my aim is bench marking and I have a chart in which I want to compare the values to other values in the field which are the dimensions. The dimension is called "Name" and I also have an input box which makes selections but instead of showing just the one selection I want the opposite which is showing everything else.

[swuehl · Accepted solution]

You could use alternate states for this.

Create an alternate state in Settings - Document properties - General tab (e.g. called AS).

Then create two list boxes for your Name dimension, one set to AS alternate state.

Select the benchmark name in AS, the peer group in the other list box.

Create a chart with dimension Name, set to default state.

Two expressions:

=Sum(Value) //or whatever you want to aggregate

= Sum(Value) / Sum({AS} TOTAL Value)   //show comparison to benchmark

[#5]

Hey thanks for the help unfortunately I have had to do something else but I will use this for later projects