robert fuschetto Posted September 9, 2021 Share Posted September 9, 2021 We created some sql tables of consolidated data for WebFocus. I discovered the powerpivot could millions or rows of data. I am no Powerpivot expert but was quickly able to set it on top of one of the sql tables. So now I can use WF as well as Excel. It comes in handy for numerous things; especially testing WF stuff. Well the PP does not allow one to removed old items from lists like a traditional pivot does by clicking Retain Items and setting to: None. This seems to be by design from what I read. There must be some way of getting rid of those values though. Anyone have any ideas Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now