{"action":"created","issue":{"url":"https://api.github.com/repos/dfinke/ImportExcel/issues/16","labels_url":"https://api.github.com/repos/dfinke/ImportExcel/issues/16/labels{/name}","comments_url":"https://api.github.com/repos/dfinke/ImportExcel/issues/16/comments","events_url":"https://api.github.com/repos/dfinke/ImportExcel/issues/16/events","html_url":"https://github.com/dfinke/ImportExcel/issues/16","id":73789065,"number":16,"title":"Unable to create pivot table using below","user":{"login":"nannnu","id":12285001,"avatar_url":"https://avatars.githubusercontent.com/u/12285001?v=3","gravatar_id":"","url":"https://api.github.com/users/nannnu","html_url":"https://github.com/nannnu","followers_url":"https://api.github.com/users/nannnu/followers","following_url":"https://api.github.com/users/nannnu/following{/other_user}","gists_url":"https://api.github.com/users/nannnu/gists{/gist_id}","starred_url":"https://api.github.com/users/nannnu/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/nannnu/subscriptions","organizations_url":"https://api.github.com/users/nannnu/orgs","repos_url":"https://api.github.com/users/nannnu/repos","events_url":"https://api.github.com/users/nannnu/events{/privacy}","received_events_url":"https://api.github.com/users/nannnu/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":5,"created_at":"2015-05-07T01:00:22Z","updated_at":"2015-05-07T01:41:53Z","closed_at":null,"body":"some how this is not working, i cant see to figure out why --------------------------------------------------------------------------------------------\r\n$hotfixdetails = get-hotfix\r\n\r\n$hotfixdetails |\r\nExport-Excel .\\mycomputer.xlsx -WorkSheetname PatchingData `\r\n-IncludePivotTable -PivotRows installedby -PivotData 'hotfixid' `\r\n-IncludePivotChart -ChartType PieExploded3D\r\n\r\n---------------------------------------------------------------------------------\r\n![error](https://cloud.githubusercontent.com/assets/12285001/7506796/e6a4baf2-f432-11e4-9377-84cb3f470231.png)\r\n-----------"},"comment":{"url":"https://api.github.com/repos/dfinke/ImportExcel/issues/comments/99674108","html_url":"https://github.com/dfinke/ImportExcel/issues/16#issuecomment-99674108","issue_url":"https://api.github.com/repos/dfinke/ImportExcel/issues/16","id":99674108,"user":{"login":"nannnu","id":12285001,"avatar_url":"https://avatars.githubusercontent.com/u/12285001?v=3","gravatar_id":"","url":"https://api.github.com/users/nannnu","html_url":"https://github.com/nannnu","followers_url":"https://api.github.com/users/nannnu/followers","following_url":"https://api.github.com/users/nannnu/following{/other_user}","gists_url":"https://api.github.com/users/nannnu/gists{/gist_id}","starred_url":"https://api.github.com/users/nannnu/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/nannnu/subscriptions","organizations_url":"https://api.github.com/users/nannnu/orgs","repos_url":"https://api.github.com/users/nannnu/repos","events_url":"https://api.github.com/users/nannnu/events{/privacy}","received_events_url":"https://api.github.com/users/nannnu/received_events","type":"User","site_admin":false},"created_at":"2015-05-07T01:41:53Z","updated_at":"2015-05-07T01:41:53Z","body":"oh ok ..got you..thanks Doug for the info\n\nOn Wed, May 6, 2015 at 9:39 PM, Doug Finke <notifications@github.com> wrote:\n\n> Nope, did it manually. I have not figured out how to do that through\n> PowerShell yet. It is on the list.\n>\n> The HotFixID is a Count and there is no way to do that in the PowerShell\n> approach\n>\n> —\n> Reply to this email directly or view it on GitHub\n> <https://github.com/dfinke/ImportExcel/issues/16#issuecomment-99673285>.\n>\n"}}