0

# Max of count in webi report

Jan 10 at 01:15 PM

103

Former Member

Hi,

I have data like this

Column

A

A

A

B

B

B

B

B

C

C

D

I need the result as B. Where it is counting and giving the maximum Value dimesion as the result.

AMIT KUMAR
Jan 10 at 01:47 PM
0

create variable Show/Hide=If(Count([Column];All) In ([Column])=Max(Count([Column];All) In ([Column]))) Then "Show" Else "Hide"

Apply the filter on Show/Hide variable where value equal to Show to get the max value.

Share
Former Member Jan 11 at 07:50 AM
0

Hi Amit,

I created variable Top =Max(Count([column];All) ForEach ([column)). I am getting the count as 5 of the highest number which is correct. Can you please help get B instead of count as 5

Show 3 Share

have you tried with my solution.

With your Top variable you got the count 5 but i don't think so it's going to be 5 every time..may me next time it is 4 or 3.in that case creating other variable will not work.

Former Member

I tried that logic its showing blank if i put filter in the table as show.Please help

Former Member

can you share your table screenshot.add the variable and don't include in the filter.After that check if values are populating correctly or not.

Former Member Jan 11 at 11:04 AM
0

12.png

I have attached screenshot of the requirement

12.png (11.3 kB)
Share
Former Member Jan 11 at 11:20 AM
0

everywhere its showing as Show only

Show 1 Share

=If(RunningCount([Country];([Country]))=Max(RunningCount([Country];([Country]))) In ([Region])) Then 1 Else 0

After that apply filter on Show/Hide and where equal to 1.

AMIT KUMAR
Jan 11 at 11:30 AM
0

=If(RunningCount([Country];([Country]))=Max(RunningCount([Country];([Country]))) In ([Region])) Then 1 Else 0

After that apply filter on Show/Hide and where equal to 1.

untitled.png (31.6 kB)
Show 1 Share
Former Member

Hi Amit,

Thanks

Shamsolution.png

solution.png (22.8 kB)
Former Member Jan 11 at 12:16 PM
0

Hi Amit,

Can you check the variable is this correct formula

=If(RunningCount([Country];([Country]))=Max(RunningCount([Country];([Country]))) In ([Region])) Then 1 Else 0

Show 1 Share

yes it's correct.what is the issue?

Former Member Jan 12 at 10:47 AM
0

Hi Amit,

Thank you very much for the solution. I changed minor reset condition and it worked.

=If(RunningCount([Country];([Country];[Region]))=Max(RunningCount([Country];([Country];[Region]))) In ([Region])) Then 1 Else 0

Thanks once again

Share
Former Member Jan 16 at 07:20 AM
0

Hi Amit

I apllied this formula:

=NoFilter(RunningSum([Amount];([[Country]];[Region])))

and used filter condition in table where it is 1

=If(RunningCount([Country];([Country];[Region]))=Max(RunningCount([Country];([Country];[Region]))) In ([Region])) Then 1 Else 0

Data is coming correct. But when i put report filter as YEAR its not working because of Nofilter.

Can you help me on this.

Thanks

Sham

Show 3 Share

why are you using nofilter on amount? if you filter on show/hide only then amount should sum up automatcially for max country & region.

Former Member

It worked Thanks. By using Nofilter it aggregates at the backend. Thanks

Former Member

Hi Amit

Thanks

1.png (17.2 kB)
Former Member Jan 17 at 03:46 PM
0

Hi ,

Thanks

Sham

1.png (16.0 kB)
Share
Former Member Jan 15 at 04:22 PM
0

Hi Amit,