Issue with Pivote table

[Anonymous]

Hello Expert,

I am using pivot table with colapse-all option.

But when I am expanding using + button if any particular column is null next column will not get diplsay.

e.g if there are column 1st country and then date next to each other.and if country is null it wont show date on click on expan button.

is there any work around?

Thanks

Kiran

[Anonymous · Accepted solution]

I got solution for same.

If some value is null association doen't work. Si while loading if I get value nulll I am replacing it with some text like N.A

It's solve my problem