Pivot Tables?

[Gallinski]

Hi All Gurus

Is it possible to use a pivot data table across tabs? I have a raw data tab (july) and a (report) tab.

If I change a commodity at the top of the report tab, i would like the data to change for each client automatically.

I have attached the file hopefully for more understanding.

Thanks.

[6StringJazzer]

I am not sure that this is what you want, since you don't show what data you want to see for the selected client. I have inserted a pivot table. To do so, I had to add a column header to indicate "client" in your data.

On the pivot table, click on the Client dropdown to select which clients to view.

However, you could actually do exactly the same thing with an autofilter on the Client column of your data. So either it's easier than you thought or I don't understand what you want your output to look like.

Pivot tables are best designed to use data that is what a database designer would call highly denormalized. That is, you have a nice matrix. But a pivot table can build that matrix for you on raw data that might look like this:

Please Login or Register  to view this content.

and so forth.

[6StringJazzer]

Dang, forgot the attachment