NPrinting Excel Using Levels for Subtotals - On-Demand Filter not applying to levels

[craigbrett]

Hi All

I have built an excel report that is using paging to create a new sheet for each "Customer" and levels to create a table with subtotals for each "level".

When I run the report from NPrinting (in the template editor) it displays perfectly as expected.

When I run the report using on demand it creates all the levels for each table regardless of the paging filter applied.

I have searched for an answer but have found nothing. It seems the selected on demand App filters have no effect on the leveling applied to the excel report.

Thanks

[Ruggero_Piccoli]

Hi,

Be sure you are applying filters to the same app used as the source of the report.

For debugging purposes, you can add a Formula in the template with =GetCurrentSelections() so you will see the list of applied filters.

Best Regards,

Ruggero

[craigbrett · Accepted solution]

Thanks Ruggero

I figured out the issue, I was using set analysis on the table measure to filter the data in the table. Once I removed the set analysis and used actual selections in the App the results come out as expected.