Posted by: ali.raza on 8 May 2023, 12:27 am EST

    • Post Options:
    • Link

    Posted 8 May 2023, 12:27 am EST

    I have a dataset like


    state: “OH”

    country: “US”

    Rider: True,

    Trainer: False,

    Owner: False


    I want to show results like this

    United States Rider Trainer Owner

    OH 21 2 3

    NY 2 4 43

    Total 23 6 46

    United Kingdon


    and so on…

    Is there any generic functions that I can use?

    Any recommendations would be helpful, thanks.

  • Posted 8 May 2023, 8:31 pm EST

    Hi Ali,

    Yes, you can add a Table control to your report and add a Country group with a State SubGroup to your table, after which you can hide/remove the Detail row.

    In your SubGroup (State-Group) Footer you can use the ‘AggregateIf’ method to only count for values that are true. Refer to the following expression:

    {AggregateIf(Rider = true, "Count", State)}

    Change the ‘Rider’ to Trainer and Owner as per columns.

    Also, add the same expression to your main Group (Country-Group) footer to get the total count of the country group as well.

    Now you are good to go, previewing the report should give you a result as per your requirements.

    Please find attached a sample implementing the same.



Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels