Remove ONE filter into formulas

[yannick001]

Hello,

I have an application, with a first page that allow the users to setup some filters, that apply to the whole application (50 sheets approx). For Example they will setup 3 filters like: Client = Client_A, year = 2020, product in (Product1, Product2, Product7)

It can be 3 or more (or less, or none) filters, base on specific dates, sub products,... and it may be evolutive.

In some formulas (quite a lot), I would like to keep the same filters, EXCEPT ONLY ONE: I would like to remove the filtering based on Client...

Do you have an idea on how I could do that?

Thank you in advance for your help

[JuanGerardo · Accepted solution]

Hi @yannick001, you can use Set Analysis to exclude one specific field from your formulas, for example to exclude any Client selection in sales:

Sum({<Client>} Sales)

or

Sum({<Client, Product>} Sales)

to exclude Client and Product selections.

JG

[yannick001]

Thank you @JuanGerardo , this is exactly what I was looking for