Does anyone know what I can't add columns to my pivot table? For some reason, when I add a dimension such as Currency or Sq.Ft. or Expiration, the data doesn't display it as a separate repeating column like it would in an excel pivot table; however, it displays it as a filter instead? In order to get around this, I have created one straight table and one pivot table but was wondering if there is anyway to display all the data in a pivot table with repeating labels just as the excel source data shows. Thank you!
