{"product":{"product_id":"1615470158","title":"DAX Formulas for PowerPivot: A Simple Guide to the Excel Revolution","price":"15.19","image_url":"https://m.media-amazon.com/images/I/51be0TTwLyL._SL500_.jpg","url":"https://www.amazon.com/dp/1615470158"},"comments":[{"body":"I'm no expert in PowerPivot yet, but from my short time with [Rob Collie's book](http://www.amazon.com/DAX-Formulas-PowerPivot-Simple-Revolution/dp/1615470158), I think you could use CALCULATE with your IF as a filter.\r\n\r\n\u0026amp;nbsp;\r\n\r\n\"=CALCULATE(COUNTROWS(table), table[Scheduled Utilization] \u0026lt; .86)\" Should return all the rows in your table that have \u0026lt;.86.\r\n\r\n\u0026amp;nbsp;\r\n\r\nThen just set your pivot up however you want.","subreddit_name":"excel","author":"Sastrupp"},{"body":"Seems that I didn't make the cut, so I will purchase. If I get the book listed above, does that mean I do not need [this](http://www.amazon.com/DAX-Formulas-PowerPivot-Simple-Revolution/dp/1615470158/ref=pd_sim_14_6?ie=UTF8\u0026amp;dpID=51be0TTwLyL\u0026amp;dpSrc=sims\u0026amp;preST=_AC_UL320_SR244%2C320_\u0026amp;refRID=15AN1D9E5Q3ZA3DWM2Z5) or [this](http://www.amazon.com/PowerPivot-Alchemy-Patterns-Techniques-Excel/dp/1615470212/ref=pd_sim_14_6?ie=UTF8\u0026amp;dpID=51cBpfZrs8L\u0026amp;dpSrc=sims\u0026amp;preST=_AC_UL320_SR242%2C320_\u0026amp;refRID=1AKK5WS15DY26WD3BCMW) book as their contents are covered in your new one?","subreddit_name":"excel","author":"LemonsForLimeaid"},{"body":"I'm fairly disappointed that nobody has mentioned **PowerPivot** (link: http://www.microsoft.com/en-us/bi/powerpivot.aspx); it's a free plugin for Excel that basically acts as an intermediary between the database and you. Great features that are designed for number crunching in marketing, easily powers out data analysis on millions of rows and integrates beautifully with the charts/etc.\r\n\r\n    -\r\nA little SQL knowledge won't hurt, but this is definitely better suited for the type of job you are describing. If you are interested there is a $10 book that starts at the basics and works its way up called **DAX Formulas for PowerPivot: The Excel Pro's Guide to Mastering DAX**\r\n\r\n    -\r\nLink: http://www.amazon.com/gp/product/1615470158/ref=as_li_ss_tl?ie=UTF8\u0026amp;camp=1789\u0026amp;creative=390957\u0026amp;creativeASIN=1615470158\u0026amp;linkCode=as2\u0026amp;tag=sq0f-20","subreddit_name":"SQL","author":"Coldchaos"}]}