Power Pivot to display text for values greater than 1 RRS feed

  • Question

  • I have a power pivot table and I am needing to display the text values for the projects associated to each department.  It does this if I put "project name" in the row field with "department name": however, it will not display the second project name on the same row, it adds a new row under the department name.  I tried putting in a custom measure, but that only showed the text value for departments with only one project and left the other departments with multiple projects blank.

    The departments could go across as columns if I could get the project names to display in the same column.  Either way my goal is to have the departments and project names in the same column or row.

    Right now I currently have this:

    Accounting  |   1    |

    Compliance |   2    |

    Clinical        |  4    |

    I would like to have this ( or flipped for columns):

    Accounting  |   Project   |

    Compliance |   Project   |   Project

    Clinical        |  Project    |  Project  | Project  | Project

    Any help will be greatly appreciated.

    Wednesday, January 30, 2013 10:23 PM