Hi,
Is it possible to have a slicer from one table controlling another, I've essentially set up 3 small tables a date table (marked as such in pq)
a product table and a sales table, all are linked.
and I like a slicers from the date and product tables to control the pivot table showing overall sales.
Any links to good tutorials welcome.
Richard.
Is it possible to have a slicer from one table controlling another, I've essentially set up 3 small tables a date table (marked as such in pq)
a product table and a sales table, all are linked.
and I like a slicers from the date and product tables to control the pivot table showing overall sales.
Any links to good tutorials welcome.
Richard.
