Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Pivoting extending the filter

Posted on 2014-03-12
4
Medium Priority
?
187 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 31

Accepted Solution

by:
gowflow earned 1000 total points
ID: 39923309
Could you post the workbook ?

Do you need a manual solution or thru VBA ?

gowflow
0
 

Author Comment

by:ZURINET
ID: 39923436
Hi Gowflow..

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

Thanks
0
 

Author Closing Comment

by:ZURINET
ID: 39923463
No.. solution .. but point awarded because of interest
0
 
LVL 31

Expert Comment

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

Featured Post

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This is an article on how to answer questions, earn points and become an expert.
Lost Word File? Eagerly, need it back? Read ahead; this File Recovery guide is for you.
The Relationships Diagram is a good way to get an overall view of what a database is keeping track of. It is also where relationships are defined. A relationship specifies how two tables connect to each other. As you build tables in Microsoft Ac…
How can you see what you are working on when you want to see it while you to save a copy? Add a "Save As" icon to the Quick Access Toolbar, or QAT. That way, when you save a copy of a query, form, report, or other object you are modifying, you…

581 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