Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Pivoting extending the filter

Posted on 2014-03-12
4
Medium Priority
?
184 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

After seeing numerous questions for Dynamic Data Validation I notice that most have used Visual Basic to solve the problem. This suggestion is purely formula based and can be used in multiple rows.
If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

604 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