cancel
Showing results for 
Search instead for 
Did you mean: 

Find the MODE of a key figures

Former Member
0 Kudos

Hi experts,


we are trying to calculate the mode of a key figures, that is the value that appears most often in a set of data.

In excel is present the function "MODE", returning the most frequently occurring value.


How can we obtain a similar result in BEx query on BW, version 7.3?


Thanks a lot in advance

Accepted Solutions (1)

Accepted Solutions (1)

Loed
Active Contributor
0 Kudos

Hi,

Can you show the layout of your report?

How about adding a COUNTER on your object then filter it with the HIGHEST COUNTER?

Regards,

Loed

Former Member
0 Kudos

Hi Loed,

I've tried to add a counter and after i've add a condition TOP 1.

The condition works well when i add in drill the field where i've made condition:

But when i take off field Price (Char) form drill, price counter is still right (with exception aggregation on maximum) but price is not filtered by condition.

Can you explain me "filter it with the HIGHEST COUNTER"?

Thanks a lot,

Dario

Loed
Active Contributor
0 Kudos

Hi,

How about not removing the PRICE (CHAR)? But in DISPLAY setting, just click HIDE or NO DISPLAY..Is it ok for you?

Regards,

Loed

Former Member
0 Kudos

Hi Loed,

thanks a lot, the mode is working fine now.

There is a way to insert in the same layout some key figures not filtered by condition TOP 1?

I've tried with constant selection on the same PRICE (CHAR), but it's not working properly.

I think there is no way, for the presence of condition, but i try to ask.

Thanks,

Dario

Loed
Active Contributor
0 Kudos

Hi,

Good to know that it already worked..You may already close the thread by clicking the CORRECT ANSWER..

Regards,

Loed

Answers (0)