Hi,
Newbie here - would appreciate anyone's input into how we could accomplish creating 'statement' type "mail merges" (couldn't think of a better term for it) using powerpivot and or Powerview in Excel 2013.
Basically I would like to know if it is possible to have both an interactive powerpivot page where you could (For example) look at a particular customer spend in a year (I'm using the Slicer to aid in selection) and then have the option to 'print' to pdf for each possible option in the slicer.
So if there were 10 customers in the slicer, the print would produce 10 statements, 1 for each of the customers with the same layout on the sheet but with different data.
Looking forward to hearing from any experts out there!
Much appreciated & Thanks
Lea
Newbie here - would appreciate anyone's input into how we could accomplish creating 'statement' type "mail merges" (couldn't think of a better term for it) using powerpivot and or Powerview in Excel 2013.
Basically I would like to know if it is possible to have both an interactive powerpivot page where you could (For example) look at a particular customer spend in a year (I'm using the Slicer to aid in selection) and then have the option to 'print' to pdf for each possible option in the slicer.
So if there were 10 customers in the slicer, the print would produce 10 statements, 1 for each of the customers with the same layout on the sheet but with different data.
Looking forward to hearing from any experts out there!
Much appreciated & Thanks
Lea