max for each base station

[SunilChauhan]

hello all ,

i am attaching excel sheet which contain a pivot table screenshot.

I want to create a listbox to select max DL value for each base station .and hour related to thosemax values.

Fast reply will be appreciated

thanks much

Sunil

[tresesco]

Hi Sunil,

Use AGGR() function to group the data by base station and then use MAX() function to get the max DL values, and again if you want the corresponding hours, you might use FIELDVALUE() function (provided your DL values are not calculated amount, i.e they are coming directly from the loaded data).

Regards, tresesco

[SunilChauhan]

but i want a listbox where i can select and result will appear in pivot table.

thanks

Sunil

[tresesco]

in list box, go to expression option and write the expression to calculate the base station wise max DL values. once they are displayed, you can select from there and the corresponding data would be displayed in pivot table.

Regards, tresesco

[SunilChauhan]

i have tried that also .thations goving one max for all station.

but i want one for each base station.

like

bs 10.0.0.12 - Max dl value

bs 10.0.0.13 - Max dl value

bs 10.0.0.14 - Max dl value

bs 10.0.0.15 - Max dl value

on all on single selection

thanks

sunil

[tresesco]

if you use AGGR() function properly with MAX() function, it should give your expected result.

[SunilChauhan]

hello i am attaching qvw file please look into and suggest me

thanks

sunil

[sushil353]

Hi check this out

max(

expression [, rank])

Returns the maximum numeric value of

expression encountered over a number of records as defined by a group by clause. Rank defaults to 1 which correspond to the highest value.

[sushil353]

Hi check this out

max(

Returns the maximum numeric value of expression encountered over a number of records as defined by a group by clause. Rank defaults to 1 which correspond to the highest value.

expression [, rank])