5 Replies Latest reply: Nov 19, 2012 12:05 AM by 913864 RSS

    Currency symbol only for grand total.

    974655
      Hi,

      My requirement is i want currency symbol $ only for grand total, all the rows in that column do not have the symbol.
      I need some your help.

      Thank you.
        • 1. Re: Currency symbol only for grand total.
          Maqs-Oracle
          Although I couldn't understand why you dont want currency format in rows, here is my suggestion.


          Create your report as

          1 dim1.column1 dim2.column2 Measure.Revenue ......... You will get values as below

          1 Value1 Dim2Val1 100
          1 Value2 Dim2Val2 200
          1 Value2 Dim2Val3 300


          UNION


          2 'Grand Total' ' ' Measure.Revenue

          Final result will be as below


          1 Value1 Dim2Val1 100
          1 Value2 Dim2Val2 200
          1 Value2 Dim2Val3 300
          2 Grand Total 600

          Now apply conditional formatting for dim1.column1 in criteria and make the values Bold
          Apply conditional formatting for Measure.Revenue and select Currency in number format.


          Let me know if it was helpful or you were looking for something else.

          Thanks
          • 2. Re: Currency symbol only for grand total.
            974655
            Hi Hussain,

            Sorry i have not explained my question properly,

            My requirement is like this

            dim1.col1 measure.Revenue
            grand total $600
            val1 100
            val2 200
            val2 300

            Up on your suggestion, by creating a union i am getting the grand total and currency symbol to only grand total value. But when coming to the results, results are sorting in alphabetical order. Because of this my grand total is coming some where in the middle. I want it on the top.

            Thank you
            • 3. Re: Currency symbol only for grand total.
              Srini VEERAVALLI
              I see a way by setting a $image before the value.
              Using Sigma icon ->select Format values->Image try to add $ image and set 'Image Placement' to Left

              Hope this helps pls mark as correct/helpful
              • 4. Re: Currency symbol only for grand total.
                Maqs-Oracle
                Hi,

                For the purpose of sorting you have to add a dummy column in report with value 1 in first report and 2 in second

                *1* Value1 Dim2Val1 100
                *1* Value2 Dim2Val2 200
                *1* Value2 Dim2Val3 300
                *2* Grand Total 600

                You can hide this column in column properties.

                Thanks
                • 5. Re: Currency symbol only for grand total.
                  913864
                  You can try what Veeravalli has suggested.
                  Create a jpg image of currency symbol using Paint and keep it inside -
                  $Middleware Home\Oracle_BI1\bifoundation\web\app\res\s_blafp\images
                  AND
                  $Middleware Home\user_projects\domains\bifoundation_domain\servers\AdminServer\tmp\_WL_user\analytics_11.1.1\silp1v\war\res\s_blafp\images
                  Restart BI services.
                  And add the custom image as shown by this link:

                  https://docs.google.com/open?id=0B_6YDYCkQgcfV2ZJQmtzempJd0k

                  Thanks.