Skip to Content
0
Former Member
Oct 07, 2009 at 03:35 PM

How to display(non-chart) multiple columns and rows using 2 filters?

20 Views

Hello,

Trying to display in a table, grid, anything (non-chart) our top 5 products, top 5 customers based on region. Data in spreadsheet looks like this:

Type Region Top 20 YTD Revenue % of All Products % of Top 5

Product Global X ### % %

Product Global Y ### % %

Product Global Z ### % %

Product Global A ### % %

Product Global B ### % %

Product Europe X ### % %

Product Europe Y ### % %

Product Europe Z ### % %

Product Europe A ### % %

Product Europe B ### % %

Customer Global X ### % %

Customer Global Y ### % %

Customer Global Z ### % %

Customer Global A ### % %

Customer Global B ### % %

Customer Europe X ### % %

Customer Europe Y ### % %

Customer Europe Z ### % %

Customer Europe A ### % %

Customer Europe B ### % %

I am using 2 filters One for Type and One for Region. If I choose Product type and then Europe, I should be able to display in a table manner the revenue and percentages for Europe's X, Y, Z, A & B products at the same time.

I can't figure out! I read in other forums that instead of using Grid to use a Spreadsheet table but I don't see that choice anywhere... Any other suggestions?

Thank you,

Sorell