Forum Discussion
Analyse in Excel- Filters not working as expected
Hi
I am using the analyse in Excel functionality.
When i put a filter on the report, for example item group the report should give me only data related to that filter.
It is querying the whole dataset and bringing all the items.
Please advise.
Regards
That is working as designed. You need to reapply the report filters manually in your Excel pivot table. I think there are plans to propagate report level filters through but that is not implemented yet. Analyze in Excel has access to the entire data model.
1 Reply
That is working as designed. You need to reapply the report filters manually in your Excel pivot table. I think there are plans to propagate report level filters through but that is not implemented yet. Analyze in Excel has access to the entire data model.