Crystal Pepsi was a pretty massive failure. I was working for Kmart at the time that stuff debuted and one of my daily duties was to re-stock the two soda machines at the front of the store. Over time the refill stockpile of all the other brands in the machine (Pepsi, Mountain Dew, Diet Pepsi, etc.) dwindled away but we never had to re-order Crystal Pepsi because the stuff just sat there. I never had to refill its slots in the soda machines because NOBODY was buying it. Eventually a Pepsi rep came to the store, took all of the Crystal Pepsi stock off our shelves and out of the stockrooms and it was never spoken of again. Haha!!
I think the only ones who made any money off of that debacle were the members of Van Halen, who licensed their song "Right Now" for Crystal Pepsi commercials.