Everyone, have been trying to color the total row in the pivot which works fine when the I have one dimension .But when adding 2 more dimensions all the rows get the same color as the total row.
have tried functions like dimensionality()=0 ; rowno()=0 ;columno()=0 but this is not working.
Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
