hi,
i encounter problem of creating pivot table as i need to drag more then 10 fields in ROWS of pivot table.
it not allow me to create pivot table . error mesg : microsoft excel cannot make this change as there are too many rows or columns.anyone have some solution for me?
beside of pivot table , what are the other way so i can have the grouping of my data as below if my field is more then 10 as it seem not supported by pivot table?

i try to group my data eg:

user_id name amount
ols001 gan........500
...........................300
...........................200

ols002 michal... 400
...............................200