Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.