Hi I have a report build out of olap cube .
The report shows some days on rows and some columns on column , the slicer on the report is all product teams and then the requiremnt is to have five more tabs with each product team on it .
Now when i emeai lthe report it shoudl show only the first page in email attachment ,but have data in for all 5 in pdf and excel .
So first question is should i create 5 queries and chnage the slicer on each queries ? Then add conditional rendering on html to show only totals page .
Is there a better approach to create same data for 5 product teams and then a sumamrized one.
Thanks,