Hi,

I have a cross tab with two rows and 4 columns
 row1  row2     col1    col2   col3  col4
2012   level 1   1        2       3      0   --->  item distinct count
           level 2    5       6       7       3

2013   level 1   2       0        1      2
           level 2   3       2         4     6

2014   level 1    1      2        0     3 
           level 2     3      1       2     4

The summarized field discinct count of item is counting per row1, I need it to count per row2, how do I do that ? I can't switch row1 and row2

thanks