I have a list report.My list report contains 20 rows.I want split the rows like
(please find the attachment)
usingConditinal variables
if([Query1].[S.NO] between 1 and 5) then('A')
else if([Query1].[S.NO] between 6 and 10) then('B')
else if([Query1].[S.NO] between 11 and 15) then('C')
else if ([Query1].[S.NO] between 16 and 21) then('D')
else('E')
What do you mean by splitting? You can define a new logical calculated item (like in your example) and perform a grouping on this , or even use this to establish sections on the list. Your topic title however mentions splitting columns :o