Hello guys,
I am currently developing a report based on Dynamics CRM online using FetchXML.
The aggregation level on datasource is request id.Every request is linked to a dealer and every dealer belongs to a region.
using the formal ssrs aggregation i can get all KPI on dealer level(aggr.png).
However when it comes to KPI on region level it become tricky.
For example:I want to get all dealer which have KPI2>85 by region(regionAggr.png).Since this KPI is already aggregated on dealer level on the report, I couldn't find a way to count the region KPI's.
Can you please help me?
Thank you,
Z