Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
Thank you @JuanGerardo , this is exactly what I was looking for