Subtotals within Crosstab

Tyler Shedden

• September 01, 2022 23:27

Hello, 

I'm wondering if there's any way to add subtotals within a crosstab table?

I've been able to use the Data Column Summary element to generate a total for each column. 

Within each column, I have different groupings that I've set up with a couple levels of a group filter, I'm trying to figure out how I can display the sub total for each group within the crosstab table while making sure it's flexible enough to handle any number of crosstab columns. 

Thanks

0

• 

  VISUI

  • Logi Info Ninja
  • September 19, 2022 16:28

  I thought this was a feature that Logi had planned to add awhile back, but it doesn't look like it was.
  
  When I was in the Expert On-Demand group I provided an example of this in the Logi 2016 User Conference application, but those applications are no longer available for download.
  
  Basically the solution was to union the detail datalayer with the group summary datalayer, where each had a column that identified the data's "rowtype" ("Main" or "Total").  The resulting data was then sorted according to the group filter, then the crosstab filter did its trick.
  
  The rowtype column was then used to apply a conditional class on the crosstab table cells so that the sub-totals were highlighted.
  
  The example also used jquery to provide a collapsible view.
  
  If I find the code, I will post it. 

  Oddly I found a screenshot of the resulting crosstab.

  0
• 

  Johnny Stevens

  • Logi Info Ninja
  • Logi Forum Guru
  • September 20, 2022 10:49

  Hey VISUI (cc: Tyler Shedden)

  I still have the ZIPs of the 2016 and 2019 Kick-Ass apps. Which report are you referencing? I can post it here. Alternatively, if you have a Dropbox or something similar, I can post the full app(s) for you.

  Let me know,
  Johnny

  0

Please sign in to leave a comment.