Need urgent help RRS feed

  • Question

  • Hi,

    My Table is like

    CustomerID   Car1      CarAmount      Car2    Car2Amount        Car3     Car3Amount
    123              Green       5000          Red     3000               Green       7000
    xyz               Red         2000         Green    4000               Green       5000
    abc              Blue        1500           Red      3500               Yellow      4500

    My Requirement is
    1)count no. of cars which are of green color
    2)Max CarAmount where car is of green

    Data is in excel.

    Is it possible in power pivot?

    Thanks in advance.

    Monday, June 6, 2011 7:10 AM