PDA

View Full Version : Power Pivot



YGKMohan
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.

Regards

Mohan

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

Regards

Mohan

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

YGKMohan
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

Mohan

xld
04-16-2013, 07:12 AM
Mohan,

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.

YGKMohan
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).