Good afternoon! I need help solving a problem. I need the result of the metric to be "BQVEND R$ S/ FRETE " where the filter on my panel called "Código do Vendedor" (Attribute) does not change the result, that is, independent of the value of "Código do Vendedore" or metric result cannot change. I tried something like: SELECT BQVEND R$ S/ FRETE IGNORE (Código do Vendedor) BY ALL IN ALL DIMENSIONS But without success.

Hi Jeferson, looking through our records, it looks like you may be a direct customer of our partner, TOTVS. They are familiar with your data model and should have first hand knowledge of how to create such metrics within their custom solutions. I would also suggest to look through our classic docs on locking aggregation, if you are working with pixel perfect.

Hi Jeferson, if you need to force your metric to ignore one specific filter but still follow any other filter, you can easily achieve this by using WITH PARENT FILTER EXCEPT. So in your case something like this should work:

SELECT BQVEND R$ S/ FRETE WITH PARENT FILTER EXCEPT Código do Vendedor