LinkBack URL
About LinkBacks
Hi,
I have a pivot chart but it wont allow me to have a slicer. I can't see any differences in any of the other pivot charts I have.
Does anyone have any reasons for why this could be?
Thanks.
Hi,
I have a pivot chart but it wont allow me to have a slicer. I can't see any differences in any of the other pivot charts I have.
Does anyone have any reasons for why this could be?
Thanks.
Sorry, but Slicer is not available on Excel versions prior to 2010
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Hi,
Nah ive used it before on the same excel!!
Not in 2007, you haven't. If you're using 2010 or later, please update your profile...Originally Posted by ACrossley1
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
You may not use slicer in .xls file. Also if pivotcache is older version it must be upgraded I think.
- Please remember to mark threads Solved with Thread Tools link at top of page.
- Please use code tags when posting code: [code]Place your code here[/code]
- Please read Forum Rules
Ahh briliant thanks. Can I ask you another question?
How do you automatically choose it to go from 'count of' to 'sum of'?
If data in the field is all numeric, Sum will be automatic; otherwise Count. You may not change this, however you may use code to reset fields - as I showed you before.
Ahh right ok, where do i put the code?
I only know the basics of the excel.
In a normal module in your workbook.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks