Is data segregation as per currency is possible in pivot.

[Jagdev Singh]

Hi Experts,
Please let me know if this is possible or not.
The attached sample file consists of data and its pivot table. There is a currency column with different currency. Is it possible to segregate the data in pivot table as per the currency. In case if there is different currency, the data should be displayed according to it and the total of it and then the other respectively.
Regards,
JD

 

[Hui]

Do you mean like below?


Simply drag the Currency field to the first column of the Pivot Table

ps: I'd also remove the Grand Total, as adding U$, Euro and INR probably isn't a great idea.

 

[Khalid NGO]

Hi JD,
My bad, i did't understand correctly,
Can you check this.

Regards,


Edit:
Posted within a mint, did't Realized Hui already replied almost same.

 

[Jagdev Singh]

Hi Hui and Khalid

This is what I was looking for.

I have a small query regarding the pivot..Is it possible to wrap text in the column of the pivot table.

Regards,
JD

 

[Hui]

Don't be afraid to Try

Right click on the Cell
Format Cell
Set Word Wrap to true
Apply
Change the Column Width

If your afraid of loosing data make a backup and work on that

 

[Jagdev Singh]

Thanks Hui for all your support.

Regards,
JD