Change layout using a bookmark

[#1]

I have a pivot table on a sheet containing several columns and expressions.

example Dept, Brand, Vendor, Total Sales

User1 want to see the layout as it is before, while User2 want to see Dept, Vendor, Brand, Total Sales.

The document is a on web server.

Can this be done using the book mark or any other way?

Thanks

[#2]

You could do it by having 2 charts are using the conditional show based on what user is viewing the sheet (via OSUser or Section Access etc)

[giakoum]

They can easily drag the column where the want it, so why bother with more complicated solutions? Just make sure that "Allow pivoting" in presentation Tab is checked.

[#4]

This works and stores in the .SHARED, so providing thats not deleted, the only issue with this is confusion when doing collaberation