Show only the top name

[#1]

Good day,

Is there a way to only show the top Flavour Name whithout using a pivot table?

Please help

See attached

Thanks

[#2]

Nope,

I still need to see all the other data, like this:

Customer     CustID     Date               Amount

Jan               5               1/4/2010        4567847

                                      4/6/2011        7847784

                                      5/8/2012        4563456

                                      12/19/2013    4784678

koos             9               1/4/2010        5456345

                                      4/6/2011        8659635

etc....

[MayilVahanan]

Hi

Please change straight table to pivot table

PFA

[#4]

I can't, i've got about 20 different fields in my actual model, I need to do this without changing it to a pivot table