Aggregation based on aggregated result conditions

  • 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

Viewing 0 posts

You must be logged in to reply to this topic. Login to reply