Crosstab

[Anonymous]

Hi guys,

Does anyone know how to count 100% of the columns.
I use 2 dimensions (Purpose and Relation) and this is my expression

Count({$<QYYYY={'$(=QuarterName(max(QYYYY)))'}>}RELATION_R)/

Count({<QYYYY={'$(=QuarterName(max(QYYYY)))'}>}TOTAL <PURPOSE_R>  RELATION_R)

that gives me 100% in line.

Please see my attached the file.

Thanks,

[#2]

Hi

Just change  <PURPOSE_R>  by <RELATION_R> 

JJ

[Anonymous · Accepted solution]

I got

Count({$<QYYYY={'$(=QuarterName(max(QYYYY)))'}>}PURPOSE_R)/

Count({<QYYYY={'$(=QuarterName(max(QYYYY)))'}>}TOTAL <RELATION_R>  PURPOSE_R)

[Anonymous]

Thank you Jean-Jacques.

I found out it too.