Hi,
Im new to pivot tables and i wonder if anyone can help with a simple query. Ive got a list of 500 prds in column A. In column B is a percentage. What i would like to do is put together a pivot table to show which products fall into which percentage ranges which i would have to define . I would like to view the tables at 10% increments so i envisge there being 10 columns beginning 0-10%, 11-20% etc and 500 rows. Is this possible and how would i do it?
Thanks
Im new to pivot tables and i wonder if anyone can help with a simple query. Ive got a list of 500 prds in column A. In column B is a percentage. What i would like to do is put together a pivot table to show which products fall into which percentage ranges which i would have to define . I would like to view the tables at 10% increments so i envisge there being 10 columns beginning 0-10%, 11-20% etc and 500 rows. Is this possible and how would i do it?
Thanks