We created some sql tables of consolidated data for WebFocus...

[robert fuschetto]

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