Why don't slicers update to reflect a timeline selection?
When I create a pivot table and add two slicers and select a value in one slicer, the other slicer updates to reflect the values that have been filtered in and out by the selection on the first slicer. When I add a timeline slicer and select a date range, the regular slicers do not update to reflect the values that have been filtered in and out by the selection on the timeline. Is this how Excel is supposed to behave? Our users are getting confused by this, as for example they select a month on the timeline and then look at the accounts slicer and see that all accounts were apparently active in that month, when they weren't. This article seems to confirm the confusing behaviour we are getting, but I would really like to get an official confirmation that this is the intended behaviour: https://office-watch.com/2017/using-slicer-timeline-together/
Pivot Table Help - Counting multiple items in a cell individually
Hello, I need some pivot table help. I’m using Excel 2010 and have scoured google for an answer without success. I currently have a table that looks like this (sample): Office Client ID Requested Funds Central X8345987 Mileage Parking Northern X435786 Parking Western U92345987 Mileage Car Insurance Central G3405695 Parking Mileage Car Insurance I have the office, client ID, and funds requested. In the funds requested column I used ALT + Enter to list multiple items in the one cell. The problem is, when I create a pivot table, this is what I get: Count of Requested Funds Column Labels Row Labels Mileage Parking Parking Mileage Car Insurance Parking Mileage Car Insurance Grand Total Central 1 1 2 Northern 1 1 Western 1 1 Grand Total 1 1 1 1 4 What I want is excel to separate the list items, and count them individually. For example, instead of providing a count of 1 for mileage and car insurance together, I want a count for mileage AND a separate count for car insurance. I want my pivot table to look like this: Office Mileage Parking Car Insurance Central 2 2 1 Northern 0 1 0 Western 1 0 1 Can anyone help me do this? Or is it even possible with a pivot table? Thanks!Help with a calculated field in a PivotTable
Hi, I am trying to write a formula for a calculated field inside a Pivot Table. I want to return the value 1 if the row value is equal to "New York", and zero otherwise. My formula is =IF(ISNUMBER(FIND(City, "New York" ) ),1,0 ) However, the formula always returns zero. Please see the attached screen shot. Thanks, Ben.Problem with multi sheet Pivot table refreshing
Hi. I have created a Pivot table from 3 worksheets through Microsoft query. It worked fine when I created. Today I have made some changes in the data and tried to refresh the Pivot table. I am getting the error "[microsoft][ODBC excel driver] the microsoft jet database engine could not find the object "Last". Make sure the object exists and you spell it's name and the path name correctly". "Last" is the name of one of the sheets and tables. Any suggestions please? If I create a new Pivot table again, it works fine. But the refresh problem starts later.
Pivot Tables - Show Details in excel 2013
Hi, I hope someone can help me please. I am using Pivot tables in excel 2013 professional, part of my works package, many times in the past I am sure I have created a pivot table, including filters, and then double clicked to get the list of details from a cell/value. But recently when I do this it comes up with an error and says I cannot do this when a filter is applied. Can anyone help please? thank you Simon
