ReportServer Forum

FLU73

Member

Registered: 2018-10-25

Strange results with computation in filters (analytical.top)

Hello,

I've a simple case where the selected table fields in a dynamic list are :Customer, Year, value

I want to display a report with the top 5 of of customers.

I use a filter on the value column where the formula is : ${analytical.top(5)}

when excecuting the preview I get a result with 9 records !?
Values of agregation are correct, these 9 customers have the correct turnover calculated from all their invoices lines in the table.

As my table contains the lines of invoices, I apply an agregration on the value column.

NB : if I don't apply agregation, and select the Invoice Nr and line Nr, I get the top 5 of Invoice lines.

IF_Eduardo

Administrator

Registered: 2016-11-01

Website

Re: Strange results with computation in filters (analytical.top)

Hi FLU73,

can you please post your exact version (rsversion.properties) and some screenshots that show the problem? You can use https://imgbb.com/ for posting these here.

Regards,
Eduardo

FLU73

Member

Registered: 2018-10-25

Re: Strange results with computation in filters (analytical.top)

Hi Eduardo,

RS version: 3.0.5-6005

here below is the screenshot of the filter definition to get Top(5)

and the result (9 records)

FLU73

Member

Registered: 2018-10-25

Re: Strange results with computation in filters (analytical.top)

Here is an overview of the underlying records of the source datawarehouse table, we can see when executing the query:
vbeln = invoice Nr
posnr = Invoice line Nr

IF_Eduardo

Administrator

Registered: 2016-11-01

Website

Re: Strange results with computation in filters (analytical.top)

Hi FLU73,

I created ticket RS-3352 for this and I will update here when we have more information.

Regards,
Eduardo