View Full Version : Sleeper:Power Pivot

04-04-2013, 06:56 AM
Dear Friends,

I just joined VBA Express Forum.

I am using Power Pivot Tool for Financial Analysis. Would like to send parameters viz., from date and to date and from customer and to customer etc.,

Can I do this in pivot Pivot. I tried but without success.



04-10-2013, 06:42 AM
Reminder to Excel masters. Request your help.



04-15-2013, 02:02 AM
when you try for serval times and failed you should ask for help

04-15-2013, 02:11 AM
Yes, I tried several times but still I was unsuccessful. I need your help. I don't mind to take some training classes on VB


Bob Phillips
04-16-2013, 07:12 AM

It can be done I am sure, but where depends on what you need to do specifically. Probably, you would setup a pivot with slicers for customers/dates.

Maybe more details on what you have, what you want, and your Excel version would help.

04-17-2013, 08:33 AM
Thanks. I am working as head of finance for retail company. We have 135 stores across the country with huge number of transactions. Over 60 GB in one year We are using Microsoft Dynamics (AX system). I am fairly good in writing SQL statements. Presently I am using power Pivot tool for data mining. What I would like to do is passing parameters into SQL, so that number of transactions will be less. I understand learning VB will ease my advantageous (in particular ado controls).