HI @estebanperalta54 

It does not filter like a GI but you could create them a new report and add the report definition for sub accounts. That may get them closer to what they are looking for. 

The same with Row Set, you could 

Hello,

Please try a subaccount filter in the Row Set’s Data Source like this: ???CON for contains CON.

Results:

Laura

Thanks @Laura02 This is exactly what I was looking for.

What worked best for us was to use the column set to filter out the P&L by cost centers. This helped avoid having to go through all the row sets.

Hi @Laura02, does wildcard work on other parameters like Company, Branch and GL Accounts?

Hello Reza, I did a quick test using BRANCH wildcards and it seems to work.  By’ seems to work’, I mean I’m getting different numbers in each column.

Laura

Thank you @Laura02. I had a look at the “Data Source” help file on Acumatica and there is no mention of the Wildcard support. Is there any source that we can refer to or do you have any personal note that you are willing to share with the community?

Hello,

I know from experience that wildcards work on Subaccounts and Branches. (I found out about the Branches today, when I tested them.) 

I have nothing else to share but can recommend that anyone wondering about Accounts, etc. perform a small test using Data Source fields in their Row Set or Column Set.

Laura