Solved

Pivoting extending the filter

Posted on 2014-03-12
4
164 Views
Last Modified: 2014-03-12
Hi all

I have PowerPivot built with excel
That retrieves values from a CSV file
Now since we are now in 2014. new data
from 2014 could not be displayed.
How can I modify the PowerPivot to display these data?
Thanks in Advance


Pivoting
0
Comment
Question by:ZURINET
  • 2
  • 2
4 Comments
 
LVL 29

Accepted Solution

by:
gowflow earned 500 total points
Comment Utility
Could you post the workbook ?

Do you need a manual solution or thru VBA ?

gowflow
0
 

Author Comment

by:ZURINET
Comment Utility
Hi Gowflow..

Just solved it..
The workbook source file is in the wrong directory..

Thanks
0
 

Author Closing Comment

by:ZURINET
Comment Utility
No.. solution .. but point awarded because of interest
0
 
LVL 29

Expert Comment

by:gowflow
Comment Utility
Well thanks but would hv preferred to provide a contribution somehow.
gowflow
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
Using Word 2013, I was experiencing some incredible lag when typing.  Here's what worked for me....
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now