Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Slicer In Table A filters Table B based on multiple conditions

So i have 'Table A', which is a list of unique customers. Table B is the total inventory, and a different column for each customer. If a customers column has the value '1', that means that the custom...
Need Help
dax's avatar
dax
Icon for Community Support rankCommunity Support
6 years ago

Hi Anonymous , 

Did you refer to my sample? it could work when you select multiple customers, and the Total column will show the status of storage. If this is not what you want, please correct me and inform me more detailed infromation(your expected output).

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Your sample was close to what i needed but the grand total column isn't showing accurate aggregations. I only need the grand total column to work. (not the grand total of rows)

  • dax's avatar
    dax
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi Anonymous ,

    If possible, could you please inform me your expected output(grand total )? In  my logic, when grand total =1, it represents that it have storage.

    Best Regards,
    Zoe Zhi

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      My data is structured differently than the example you attached. The formula doen't work. In my case i cannot restructure the data