How can we create a chart bases on Sum(Revenue) and Category with Revenue format to be dynamically updating

[san thom]

Hi All, I need a solution for this one ASAP. Can someone help on this, so basically we have a scenario wherein we have a sum(Revenue) field and like to change this format in terms of GBP or USD by some controls, Also would prefer to convert it into short formats like K and Millions ..Please provide the solution by either Iron python or any other codes.

[Donald Johnson]

What TIBCO Product is this for