Hi Team,
i have created an interactive grid using pivot option and i have a line with name of TOTAL in finish unit column,
now i want to set that if Grid found TOTAL text in Finish Unit column then change the Row color with GREY instead of white.
i have tried to use CSS but unable to adjust this , can anyone please guide how can i set this condition in my interactive grid if there is css code please guide with example or if there is builtin option in interactive grid.
waiting for response thanks in advance….
whole data fetch from sql script
here is a query for reference (note this is grouping query with adding total)
select SBU_FINISH,
nvl(FINISH_UNIT, 'Total') FINISH_UNIT,
--FINISH_UNIT,
OMS_MONTH,
oms_month_no,
sum(ORDER_QTY) ORDER_QTY,
sum(COUNT_STYLE) COUNT_STYLE
from ( select * from MY_TABLE
WHERE TO_DATE(TO_char(oms_date), 'MM-DD-YYYY') between TO_DATE(:P7_DATE1, 'MM-DD-YYYY') and TO_DATE(:P7_DATE2, 'MM-DD-YYYY')
AND (to_char(SOLD_TO_ORG_ID) IN ( SELECT regexp_substr(:P7_BRAND,'[^,]+',1,level) FROM dual CONNECT BY regexp_substr(:P7_BRAND,'[^,]+',1,level) IS NOT NULL) OR :P7_BRAND IS NULL)
AND (to_char(PARENT_CUSTOMER_ID) IN ( SELECT regexp_substr(:P7_CLIENTS,'[^,]+',1,level) FROM dual CONNECT BY regexp_substr(:P7_CLIENTS,'[^,]+',1,level) IS NOT NULL) OR :P7_CLIENTS IS NULL)
)
GROUP BY GROUPING SETS ((SBU_FINISH,FINISH_UNIT,OMS_MONTH,oms_month_no),(SBU_FINISH,OMS_MONTH,oms_month_no))
screen shot attached for reference.
