Values area not creating new columns

Category: sql server powerpivotexcel


Albo44 on Fri, 02 Sep 2016 17:31:38

Hello. I have dates from a date table Year, Quarter, Month. They are all coming up as different columns--which I guess makes sense, since I created these as calculated columns in the date table. However, when I try to add fields into the values area, it is not adding new columns but rather adding weird rows. So, I'll get a quarter to date, and then add year to date in values and it formats Below each instance in the same row. 


Albo44 on Fri, 02 Sep 2016 17:46:22

Figured it out. Values were using row labels.