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 December 11, 2018 at 7:40 pm #11264 ZZZZZParticipant Started: 5Replies: 21Total: 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 December 12, 2018 at 6:49 pm #11265 ZZZZZParticipant Started: 5Replies: 21Total: 26 hi any updates on my question ? December 17, 2018 at 4:38 am #11273 ZZZZZParticipant Started: 5Replies: 21Total: 26 hi any updates ? January 21, 2019 at 3:23 pm #12030 ZZZZZParticipant Started: 5Replies: 21Total: 26 Any updates to my question ? Author Posts Viewing 4 posts - 1 through 4 (of 4 total) You must be logged in to reply to this topic.