Skip to Content

How can i show a "$" only on the first row of a cross tab?

Hi All,

I have a cross tab with Rows and Summarized Fields. Is it possible to show first row with value and a "$". Below is what I expected for my result. Thank You.

NameCompanyAmount 1Amount 2AlABC$100.00 $200.00 BobEFG205400CatXYZ310600..Total$615.00

$1,200.00

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    May 11, 2017 at 09:19 AM

    Hi Frankie,

    Right-click one of the summary cells > Format Field > Number tab > Click the Customize button > Currency Symbol tab > Click the formula button beside 'Enable Currency Symbol' > Use this code:

    if CurrentRowIndex = 1 then crFloatingCurrencySymbol else crNoCurrencySymbol

    -Abhilash

    Add comment
    10|10000 characters needed characters exceeded

  • May 12, 2017 at 02:54 PM

    It works!. Thank You Abhilash.

    Add comment
    10|10000 characters needed characters exceeded