I'm new to using PowerPivot but very proficient in Pivot Tables. I've imported data from a CSV file, all the whole data set came in as TEXT columns. I then set the Data Types to Decimal, Whole Numbers, Dates, etc and I also set the formats respectively.
However, when I finally get to the subset...