filters in a matrix

[r388]

Hi,
I want to have filters in a matrix. But the problem is that the filters are differents belong the cells corresponding to data.
For instance, for one cell, the filter is the field1 whereas the filter for the second cell is the field2 etc....
The aim of my data is to count the number of societies. Moreover, my rows are grouped by groups of concessions of societies and by concessions of societies.
Have you any ideas?

 

[Catadmin]

Not quite sure I understand what you're aiming for here.

Are you saying that the data in each cell is affected by the data right before it?

Could you give us an example of what your raw data looks like and how it's defined? Then an example of how it should look on the report?

Thanks.

Catadmin - MCDBA, MCSA
"If a person is Microsoft Certified, does that mean that Microsoft pays the bills for the funny white jackets that tie in the back???

 

[r388]

The aim is to count the number of societies which correpond to the criteria. To begin, users have to choose a parameter in order to display a matrix. It's the only filter in the matrix. The matrix is composed by:
-----------------------------------------------------
|Value of parameter
-----------------------------------------------------
|Request1 |Request2
-----------------------------------------------------
group of |concession| count |count
concessions | |(societies) |(societies)
of societies | | |

But the problem is that the filters are different in the resquest 1 and in the request 2. But the result must be ordered by group of concessions the concessions. I have to display the result in one table. I don't know how to do that.

 

[Catadmin]

Nest your matrices. You can put one inside one of the results cells, or you can put a table inside of a matrix or a matrix inside of a table.

Then you can define both matrices (or whatever combo you choose) with seperate datasets but use the same parameter.



Catadmin - MCDBA, MCSA
"If a person is Microsoft Certified, does that mean that Microsoft pays the bills for the funny white jackets that tie in the back???