![]() |
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