Calculated Field

[#1]

Hi all,

I am using QV 8.5 and I don't know how to use a calculated field (AVG) to monitor how many cases of each field value occurs using various selections criteria.

I attach a very simply example of what i am triying to do.

The pourpose is to have a table or Graph to count how many vendors have the AVG of sales in each range (1.5, 2.0, 2.5, etc.) after varying the selection criteria.

Example:

AVG(SALES) VENDORS

5.0 3

5.5 2

6.0 1

Thank you in advance,

[#2]

I cant download you file, but you can put a calculated dimension (AVG(SALES)) and in your expression put COUNT(VENDORS)

[#3]

Erico,

Thank you for your answer,

Thats what I am doing, but when you change the selection criteria (YEAR,MONTH,ETC.) The AVG(SALES) also change an the (COUNT(VENDORS) is different for each case.

Thanks,

.

[#4]

If you dont wanna change the graph, you need untached object or using a sel analisys!!!!!

[montubhardwaj]

Because when you are changing your selections say YEAR, for 2009 , you will have diff.Sales value and also no of Vendors for that Sales than compared to YEAR 2010. So automatically the numbers will vary.

Regards,

Sharma