Results 1 to 6 of 6

Thread: Power Pivot

  1. #1

    Smile Power Pivot

    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.



  2. #2


    Reminder to Excel masters. Request your help.



  3. #3
    when you try for serval times and failed you should ask for help

  4. #4
    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


  5. #5
    Distinguished Lord of VBAX VBAX Grand Master xld's Avatar
    Apr 2005

    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.
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber

  6. #6
    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).

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts