delivering an excel pivot with one slicer already chosen

Hi, i stood up a relational sql server receivables table with a column called "AsOfMidnightDate".   I'm ok with ssis so this isnt necessarily an ssis question.  I'd probably use ssis to automate deli...