Newbie here.... I am setting up 2 powerpivot tables with one set of slicers. What I am trying to do is have the slicers filter the first pivottable, but then the second powerpivot table results be based on the results of the first. From my searching it looks like I need to relate the two powerpivot tables, but where/how do I do that? The 2 powerpivot tables are getting their data from the same data source. NOTE: I see many submissions for how to get one set of slicers to filter 2 powerpivot tables at the same time, but that is different.
Detail of powerpivot tables: One table shows Date Ordered. Each row is a different month of the year. The columns are different products. The second powerpivot table is the Date Shipped. Each row is a different month of the year. The columns are different products. As the first table is filtered by the slicers, I am trying to get the 2nd table to reflect the ship dates for those products that make up the resulting data set of the first table, comparing the lag between when items are ordered vs when items are shipped.
Thanks in advance.
Detail of powerpivot tables: One table shows Date Ordered. Each row is a different month of the year. The columns are different products. The second powerpivot table is the Date Shipped. Each row is a different month of the year. The columns are different products. As the first table is filtered by the slicers, I am trying to get the 2nd table to reflect the ship dates for those products that make up the resulting data set of the first table, comparing the lag between when items are ordered vs when items are shipped.
Thanks in advance.
