3 Replies Latest reply on Feb 25, 2015 10:48 AM by diego.medrano

    Overlapping text when Crosstab to Excel

    n.t

      Hi,

       

      When I am using the Crosstab to Excel function I get the following error: "The dataset contains multiple values for a single cell. Only the first value will be displayed. Please consult the help index entry on "overlapping text" for clarification".

       

      I am using multiple measures all combined in the Measure Values shelve. Then I have the following calculated field for every measure: if [Select a measure] = "Sales" then [Daily average units] else null endif. I am using this method because the measures have to be formatted differently and I found this method on this forum (percentage and normal values). However, when I export the crosstab to Excel only some values are filled.in the Excel table. If I select another measure, and then use the export, other fields are filled. See below for the example (only June is filled for the measure Sales).

       

      pic.png 

       

      Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
      2.553

       

      When I export as data (.mdb) then the table is just filled as shown in Tableau and no values are hidden.

       

      Anyone knows a solution for this?