Create a Pivot Table in RTF with more than 1 columns

Dear All,

I have a problem in creating pivot table using RTF document.

I saw the example given in the bi publisher userguide

But in the sample the pivot table is only for 1 column. can I create the pivot table group by more than 1 columns?

In my sample (attached)

I want the data to be group by entity, by currency code but the report should display the exchange rate between currency code & USD.

Could this be done?

Many thanks before.