Home Forums Power Pivot last six or last seven prices per item

This topic contains 3 replies, has 1 voice, and was last updated by  ZZZZZ 5 months ago.

Viewing 4 posts - 1 through 4 (of 4 total)
  • Author
    Posts
  • #11264

    ZZZZZ
    Participant
    • Started: 5
    • Replies: 21
    • Total: 26

    Hi,

    I’m looking for a power pivot formula that would do the following

    I have my invoice history detail table, in power pivot that looks like this.

    Customer number,Customer  name ,Invoice date ,Invoice number ,Item number ,Item Description ,Price ,Amount Etc…

    What i would like to do is to be able to list an item number and a Customer Number,  and have the pivot table list me the last six prices that, that particular customer paid for that particular item

     

    P.S. Maybe even to have a slicer that i can select last six ,last seven etc…

     

    Thanks, any help is greatly appreciated

    #11265

    ZZZZZ
    Participant
    • Started: 5
    • Replies: 21
    • Total: 26

    hi

     

    any updates on my question ?

    #11273

    ZZZZZ
    Participant
    • Started: 5
    • Replies: 21
    • Total: 26

    hi

     

    any updates ?

    #12030

    ZZZZZ
    Participant
    • Started: 5
    • Replies: 21
    • Total: 26

    Any updates to my question ?

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic.