Group Sorting - Year and Quarter

lightstudios

Link to test case: https://live.datatables.net/zagakesu/12/edit?html,output
Debugger code (debug.datatables.net): https://debug.datatables.net/ixukem (the table in question is marketing-report-grid-new)
Error messages shown: No error, can't figure out functionality
Description of problem: I am displaying data by year and then by quarter. So the way I want the data to display is one row with year and Q1 and then "" for year and Q2, "" for year Q3...etc.

Like this:

2018 Q1
Q2
Q3
Q4
2019 Q1
...etc

Is there a way to do group sorting like this? So it will initially display this way and then you can sort by year but the quarters stay grouped with the year?

Thank you

kthorngren

Sounds like something the RowGroup extension can help with. Sounds like you will want to use the multi-level grouping option like this example. If needed use rowGroup.startRender to change the default grouping output.

Kevin