Table/List

Table/List

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

• 

  ali.raza

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  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
  
  London…

  and so on…

  Is there any generic functions that I can use?
  
  Any recommendations would be helpful, thanks.

• 

  anand.sinha

  

  • Post Options:
  • Link
    Copy

  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.

  Regards,
  
  Anand

  CustomerReport.zip