Hi and good day everyone.

1. My report consists of "Current Month" and "Previous Month" charts on one page.

2. I have two slicers to filter the current and previous month's items, respectively.

3. The code below is well running for the Current Month (1st slicer) in my report.

4. My question is, what do I need to add so that when I run the code, the second slicer (Previous Month) will filter the data simultaneously with the first slicer according to the order and save it into pdf?

5. For now, it only runs one slicer.

6. p/s: For the time being, I do not intend to join both slicers because of the different data sources and the lot of data involved. The second is I prefer to readjust this code. Maybe for the following report, I will consider it.

I appreciate any help you can provide. Thank you.

Please Login or Register  to view this content.