Ignore filter selection in a table

[delbooth]

Hi.

I have a filter of account names.  I also have a table that lists sales by month and when you select an account in the filter it only gives the sales for the selected account.  Is there a way in the set analysis of saying ignore the account name in a table measure column so you can get a total sales and sales for a selected company in one table.

I have tried

Sum({$<Year ="2018",[Account Name]=  , [Sales Code]={"S","R"}>} Sales) and

Sum({$<Year ="2018",[Account Name]=''  , [Sales Code]={"S","R"}>} Sales)

Filter selection set to Company A

Month   Sales   Total sales

Jan         100          250

Feb         80             150

Thanks

[OmarBenSalem]

do the same thing but in the script where u have ur field [Account Name]

load ...,

[Account Name],

if(wildmatch([Account Name],'*VAL*','*PIC*','*BACK*','ER*','*DH*','*ECO*'),[Account Name],Null()) as NewField

from source;

Now in ur expression :

change it as below:

Sum({$<Year = {"2018"}, NewField, [Account Name]=, [Sales Code] = {"S","R"}>} Sales)