nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Group Dataset by Column

smgomes

Hi,

it´s possible group a Dataset using a Table by column?

Example:

Client | Jan | Feb | Mar | Apr | May | Jun | .....
xpto 10 20 10 0 0 0
ayx 0 30 40 5 0 0

Total 10 50 60 5 0 0

Thanks!

Find more posts tagged with

Comments

mwilliams

Hi smgomes,

This looks like a crosstab style report to me. How does the data look in your dataSet?

smgomes

Hi mwilliams 
 
thanks for reply. 
 
I found a solution for my problem

I have a Table grouped by Client, with 14 Columns. 
 
Column #1 = Client ID 
Column #2 = Name's Client 
Column #3 = January 
Column #4 = Fev. 
Column #5 = March 
.... 
 
In the group footer i created an Aggregation to SUM all Total's Documents with a Filter Condition: 
 
datedocument.getMonth()==0 for January's Documents 
datedocument.getMonth()==1 for Fev's Documents 
datedocument.getMonth()==2 for March's Documents

Thanks 
 
 
<a class='bbc_url' href='http://www.twitter.com/smgomes'>Sérgio Gomes (smgomes) on Twitter</a>

mwilliams

Sergio,

Glad you found a solution. Let us know whenever you have questions.