ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   filtering pivot tables (https://www.excelbanter.com/excel-programming/378686-filtering-pivot-tables.html)

[email protected]

filtering pivot tables
 
I'm doing some analysis of shipping rates where we have many lanes
(origin - destination combinations).
I don't have prices for every lane from every courier which makes
bottom line comparisons in a pivot table difficult as one column may be
including more 'blank' values than another.

What I'm thinking is to have a tick box that allows you to select which
of the available pivot table columns to include which then filters them
(and of course adjusts the sum totals) based on lanes where ever
courier has a price (i.e. no blanks)

Is there a template around for something like this or could you give me
some ideas on how to design/code this?

Thanks
Oliver



All times are GMT +1. The time now is 02:53 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com