GridViewColumn with multiple currencies

[Siva Harsha Vardhan]

Hi there,

I have a requirement where the GridView Column has multiple currencies and the aggregate needs to show the result separately for each currency. For example, consider the attachment where screenshots are shown from the Demos of GridView Totals. In the attached screenshot from the demos, dollar is the only currency and hence the sum works fine. But, can we display separate results for each type of currency when some rows have Currency "C1" and some have Currency "C2" etc.. ???


~ Harsha

[Siva Harsha Vardhan]

(bumps)

sorry for bumping... was hoping for a reply. Maybe I wasn't very clear with explaining, I can probably explain a little bit more


Unit Price
$100
$250
$560
Rs.300.56
$256.78
$520.36
Rs.360.32
Rs.596.01
$236.86
Rs.569.87

Sum: $1924, Rs. 1826.76   // to be shown in the Grid Footer

As you can see, I need the sum to be displayed for each type of currency in the Column.

Is this possible?? Can you kindly guide me with achieving this?


Thank you.

~ Harsha