Pivot table not working properly

[#1]

Hi,

I have data in the pivot table.

i have that + sign in all the fields.

so i should be able to expand it when i click on the + sign.

but the + sign is not working for first few data.

check the attached image

[#2]

the picture is not really showing you problem cause you expanded you first dimension and the second one is not expanded at all

[#3]

sorry i didn't look right at the picture!

[#4 · Accepted solution]

Hi all,

I found some information in Community for this problem.

Just go to your pivot table.

right click on table and select Collapse all, till it collapse to the first field.

then again right click and select Expand all till it expands to the last field.

it will work properly.