1. Create a new Smart Field, type Condition.
  2. In the Input parameters, press ADD.
  3. Select Expression Wizard.
  4. Select Gift, is equal to, Cash.
  5. For the Value for fields that meet this criteria, type Cash.

    Include Options

  6. Continue for each gift type needed, changing the Value for the column you want

    Include Options

  7. In the Default Value, select Gift_TypeGifts.Type

    Include Options

  8. Name the smart field Gift_Type. 
  9. Add Gift_Type as a new dimension to the Gifts Cube. 
  10. Add Type as a new dimension, making Gift_Type its Parent Dimension.

    Include Options

  11. Create a Pivot report. 
  12. Put Amount in the section captioned Drop Totals or Detail Fields Here. 
  13. Put Gift_Type as field above. 
  14. Select just the Types wanted.

    Include Options

  15. The ability to easily pivot on the types is achieved.

    Include Options