Issue with Pivot table

[shahnaz0794]

Hello Team

  While working on Pivot table it was seen that bullet separated sentences are not getting separated in the pivot tale.

Ideally the separated lines should be visible in next line or row but the same is not happening.

The tooltip is showing correct but the same is not reflecting in the pivot table.

Please let me know how can the same be achieved. Please look into the image for clarity

Expression used is:      =Replace([Fiscal Year Goal], chr(10),chr(10)&chr(10)&'•')

Thank you

Shahnaz

[Bessieey]

---

@PrepaidGiftBalance wrote:

Hello Team

  While working on Pivot table it was seen that bullet separated sentences are not getting separated in the pivot tale.

Ideally the separated lines should be visible in next line or row but the same is not happening.

The tooltip is showing correct but the same is not reflecting in the pivot table.

Please let me know how can the same be achieved. Please look into the image for clarity

Expression used is:      =Replace([Fiscal Year Goal], chr(10),chr(10)&chr(10)&'•')

Thank you

Shahnaz

---

There is a restriction in databases that fields can't have numeric names, or at least not start with a number or underscore but this is dependent on the database type. Allthough you see numbers the field Thn_Buat_u must be text as it contains multiple values and commas. Can you explain more about what you're expecting from this pivot table? Perhaps it would be better to do this in Excel or similar due to fuzzy types in spreadsheets.