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
Anonymous's avatar
Anonymous
Not applicable
6 years ago

The data then wouldn't aggregate correctly though. It would show more inventory than is truly available if more than one customer is selected.

 

For example, a single hot dog in the warehouse can be available to multiple customers (although not all customers). if i unpivot the data the report will show that there is more hot dogs in our inventory than are truly available in the warehouse.

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

Hi Anonymous , 

I am not sure your requirement, you could referto my sample for details. If this is not waht you want, please correct me and inform me 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

    I need a single column in the matrix that displays counts available inventory. This column must filter for the selected customers (whether it be a single, multiple, or all customers).