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; } } }

Auto populate Matrix

flatbirt

Hello,
 
I have some data:
 
 
User Year Data 
 
User1 2009 xls
User2 2010 xls
User3 2008 xls
User1 2010 xls
The Matrix I want to create should look like this:

Find more posts tagged with

Comments

sidrees

Hi, 
As per your attached screenshot I think you should use Crosstab to display the data in Rows and Columns,
Download this book and go through Chapter20
 
and to highlight certain data you need to select the data binding and then in Property Editor select Highlights, there you can add multiple highlights, it is easy to use,

flatbirt

Thanks sidrees,
 
I worked for through the tutorial and the auto populate works fine for the header of the columns and rows but what I don't get in my example is how to just add the content of the Data column as a string (e.g xls,doc) to the crosstab without doing an aggregation.
 
I tried FIRST and data type string. The Result should like this e.g.
 
<img src="http://developer.actuate.com/community/forum/uploads/monthly_05_2016/post-78225-0-50833000-1463661101_thumb.png" alt="post-78225-0-50833000-1463661101_thumb.p">
 
 
 
Is it possible to get this kind of matrix?
 
Thanks again

pricher

Hi,
 
Here's a working example based on your data.
 
In the data cube, the Data field is aggregated using the FIRST function and its data type is String:

flatbirt

Thank you for your effort Pricher,
 
Your example was very clear and helpful to me. Now everything works fine for me.