1
I'm importing data into Excel Pivot Chart from SQL Server. I'm trying to filter out Values (decimal type on SQL) below a certain threshold.
For this, I click PivotChart filter and see that filter may be applied on both Legend and the Axis. I click the drop down menu and see that both the Axis fields and Legend fields have Value Filter for Y applicable. I choose Legend Fields (inadvertently) and set the "Max of Y" "is greater than" 15. Data with value 7 still shows up. (Same is true if I apply the filter on Axis as well). How can I achieve this?
Thank you
Stackoverflowuser
Posted 2015-02-27T13:44:37.197
Reputation: 111
I would build this into your SQL query (e.g. add a where value < x statement)-then Excel doesn't have to filter anything. Is there a reason that wouldn't work? – dav – 2015-02-27T18:46:15.873
Thanks mate.kinda worked for me. I just wanted to make it from inside Excel for manageability purposes. btw, any idea about why date (axis) would lose its order after importing date. i.e. 27.02.2015 hh:mm coming after 01.03.2015 hh:mm? – Stackoverflowuser – 2015-03-02T08:30:45.360
@dav: could you post the comment as an answer, so the question can be closed as having an answer? – agtoever – 2015-03-06T11:22:14.030