2 Replies Latest reply on Apr 25, 2018 6:13 PM by Richard Couillard

    Combining Crosstab Views into Single View

    Richard Couillard

      Hi. I have several crosstab views that are based on much of the same information and would like to combine them into a single view with the data from each view appearing as a separate column in the combined view. I am attaching the twbx file and the 3 worksheets I would like to combine are  "YTD", "Projects" and "Rework", the 3 blue tabs.

       

      Currently I am combining the 3 worksheets onto a dashboard but since the row information for each table is the same (Unit, Project, CNT(Project #)) it would be much more appealing to the viewer to have a single table with the data appearing in the correct column/row for each of the clients rather than scanning across 3 different tables.

       

      I can't seem to figure out how to setup the columns to have the correct data appear in each of the columns. Is this possible to do and if so, any idea how?

       

      Thanks