4 Replies Latest reply: Jan 10, 2013 2:43 AM by 901916 RSS

    Grand Total color

    970365
      Hi
      I am using 10g.I have pivot table re[port. In this report 3 rows dimension and 4 measure values.

      Now i set grand total based on row values.Grand total backround color dark blue display upto dimension row.After dimension sum(measures) shows normal color.

      My requirment is i should display full row for grand total is dark blue.How can i set pls let me know?

      Thanks
      Gram                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           
        • 1. Re: Grand Total color
          Srini VEERAVALLI
          Try this
          Rows at Sigma sign->Format Lables
          Use Custom CSS Style->
          background-color: #ECEFF3; color: black;

          If works pls mark as correct :)

          Just in case you want to use same color of above values use
          color: #3C3C3C; instead of color: black;

          Edited by: Srini VEERAVALLI on Jan 9, 2013 9:52 PM

          BTW: For your other post "Pivot Col Heading " can you send me screenshot to my email

          Edited by: Srini VEERAVALLI on Jan 9, 2013 9:55 PM
          • 2. Re: Grand Total color
            970365
            Thanks a lot veera.I will send you mail.Pivot row color is still same.Could you please advice me how to change.

            E.g
            Pivot table have the 2 column ID,name, and Measyure Sal1,Sal2
            Now result is

            ID NAME SAL1 SAL2
            1----A------1000-----2000
            2----B-------3000-----5000

            Grand Total 4000-------7000

            My requirement is
            I should display entire row in single color.Not only Grand Total backround.Entire row upto SAL2 total.


            Thanks
            • 3. Re: Grand Total color
              970365
              Fixed formate values and formate heading
              • 4. Re: Grand Total color
                901916
                Hi,
                How did you achieve it? what do you mean by format values and heading?

                Thanks,
                Anitha.B