Marti McKee
New Member
Hello,
I have searched and cannot find this answer. I have multiple tables with data, each table identified with a SKU number, and a QTY. I then used the data model functionality and combined all tables into 1 pivot table. I would like to filter data from each data table on my pivot table, but I cannot determine how to do this. Essentially, this would filter columns on my pivot table, and see only the data tables I needed at a particular time.
Can someone help?
I have searched and cannot find this answer. I have multiple tables with data, each table identified with a SKU number, and a QTY. I then used the data model functionality and combined all tables into 1 pivot table. I would like to filter data from each data table on my pivot table, but I cannot determine how to do this. Essentially, this would filter columns on my pivot table, and see only the data tables I needed at a particular time.
Can someone help?