Electronic Reporting - Filter a datasource and then group it

(0) Share

Report

Posted on by Community Member Microsoft Employee

Hi,

I'm trying to create a configuration to export the ledger trial balance using ER.
I've created 2 parameters, the DateCode and the DimensionSetName.

I then used those 2 parameters to create a filtered calculated field using DimensionFocusBalance table (using the filter function).
I then created a group by on that calculated field, but I keep getting error saying "Validation error: The list expression of FILTER function is not queryable."

I'm using the Filter function and not the Where function in the hope that it would be more efficient in fetching the data.
(If I use the Where function, it works OK)

Is what I'm trying to do possible with ER or is there anything that I need to change to make it work?

Another question is, is there a way to make the user input parameters to be mandatory?

Thanks