Search results

Hi I have a Pivot table like this (named regionSales): Region1 |------Advertiser1: Revenue1 |------Advertiser2: Revenue2 |... |------Advertiser10: Revenue10 Region2 |------Advertiser1: Revenue1 |------Advertiser2: Revenue2 |... |------Advertiser10: Revenue10 Region3 |------Advertiser1...

Hi there, Its nice to read these forums and find answers to almost everything :). Tried to find something in which my dashboard could be based on with no success so here It is what Im thinking about and ill appreciate if someone could point me in the right direction. I have 2 sheets: sheet...

also tried with Worksheets("Dashboard_Inputs").PivotTables("Pivot_Sites").PivotFields("Site").CurrentPage = seriesName.Value with no luck

Well i finally found It... just a typo on data sheet. By the way, I am now in troubles almost with the same in a public function (based on chandoo's tutorial for using tabs / http://chandoo.org/wp/2011/07/20/interactive-dashboard-using-hyperlinks/). I want to change a pivot table field...

Hi, I'm just modifying a pivot table field from a dropdown list and all of my pivot tables work except one (Pivot_Devices) and they have just the same code: With Worksheets("Dashboard").Shapes("months_unique").ControlFormat Worksheets("Dashboard").Range("C2") = .List(.Value)...

Thanks a lot for your quick reply!

Hi, I need to sum several fields in a column based on conditions from others. This is it: ColA / Col B / Col C --------------------- Jan / castle / 10 Feb / house / 6 Mar / flat / 7 ... I'd need to get all sums for items matching (ColA = Jan) AND ((Col B = castle) OR (ColB =...

Thank you for your quick answer. I have a pivot table which shows just "Concept" and "amount" taken from a big table which has: Sales person Start date (contract) End date (contract) Total amount And several columns with formulas to distribute amounts between months. The thing is that...

Hi, I've just known about this site and It is great! Thank you for your work. How could I get from other sheet's pivot table values with a certain text in a field? I mean, i have a pivot table showing 2 columns: Concept | Amount I want to get to my dashboard SUM of amount for concepts...