10 Replies Latest reply: Oct 5, 2018 9:31 AM by omar bensalem RSS

    Ignore filter selection in a table

    Del Booth

      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