Hello Everyone,
Please bear with me as this is my first official post on a forum. I am not sure I am doing this the right way and no more at the right place. Do not hesitate to point me in the right direction.
Si I am trying to build an Excel base material ressource planner and it's doing great so far but one feature I would like to include is still a mistery for me. I am tring to integrate a slicer to will allow me to filter the material that is shown in the pivot tablet based on a different table. I know the way around this is probably within PowerPivot but I have not been able to get this working so far. I am including more detail explanations (picture)with simple dataset if it can be more relevant somehow.
Thanks in advance and please do not hesitate if any information is missing !
Please bear with me as this is my first official post on a forum. I am not sure I am doing this the right way and no more at the right place. Do not hesitate to point me in the right direction.
Si I am trying to build an Excel base material ressource planner and it's doing great so far but one feature I would like to include is still a mistery for me. I am tring to integrate a slicer to will allow me to filter the material that is shown in the pivot tablet based on a different table. I know the way around this is probably within PowerPivot but I have not been able to get this working so far. I am including more detail explanations (picture)with simple dataset if it can be more relevant somehow.
Thanks in advance and please do not hesitate if any information is missing !
