Data Set
It looks irregular.
Follow the below steps to achieve the Alternating Style color
step 1: Add a column outside the details group, and thro expression give the same expression which we use for the generic alt row color style..
My Matrix Report
RowGroups on Type
Col Groups on Category
My Pivoted details will be the - value
My sample matrix looks like ,
As a generic procedure (by adding expression nothing) mod 2 =1,"White","LightBlue"))if im trying to add expressions in details my report looks doesnt give me the exact output,
= iif(rownumber(
It looks irregular.
Follow the below steps to achieve the Alternating Style color
step 1: Add a column outside the details group, and thro expression give the same expression which we use for the generic alt row color style..
step 2: then hide that column by column visibility feature
step 3: Now write BG expression in the details column calling the value of the newly created column wr you have given the color dynamically
Thats It.. Now you have your output as expected, find below
No comments:
Post a Comment