Rowno() in pivot table

[#1]

i need mod of row number for each row in pivot table.

i use in expression as --  mod(rowno(total),2)

nut its behaviour changes when i do drill down  and no value is shown

please help me out

[Gysbert_Wassenaar]

The rowno() is calculated for the lowest level shown. If you expand only certain values of a dimension then the rowno() will be shown for these expanded rows. And the rowno cannot be displayed for the collapsed dimension values.