How can i add both locale format and currency to number?

  • Currency / Dollar ($) - this gives you the abbreviated version which is no good for reporting.
  • prefix:$ - this gives you an unabbreviated version but without the commas, making large numbers hard to read.
  • Misc / Locale Format - this gives you the unabbreviated version with the commas but no currency sign.

example:
suppose number is 13454.34
My requirement is $13,454.34

what is your data source

Mysql

Thank you for your response.

But unable to show total sum value in table footer

that is a setting you have to configure for table vidualization a separate issue