V villival Member Apr 20, 2016 #1 Hi All, I am looking power pivot for client presentation , please help me creating power pivot am attaching sample XLS -if i click on event name is should get how many P1 p2 has been raise Thanks in advance Attachments sample.xlsx sample.xlsx 38.6 KB · Views: 4
Hi All, I am looking power pivot for client presentation , please help me creating power pivot am attaching sample XLS -if i click on event name is should get how many P1 p2 has been raise Thanks in advance
Chihiro Excel Ninja Apr 20, 2016 #2 Why PowerPivot? Also, it's not clear your exact need. I'm guessing you want it summarized by Event Name (P3 Event, P3 SRQ etc). See attached with pivottable. Attachments sample (5).xlsx sample (5).xlsx 43.2 KB · Views: 3
Why PowerPivot? Also, it's not clear your exact need. I'm guessing you want it summarized by Event Name (P3 Event, P3 SRQ etc). See attached with pivottable.
