11 Replies Latest reply: Jul 2, 2015 10:38 PM by Ian McGivern RSS

    Loading Excel spreadsheet with four worksheets

      Hi,

       

      I have one spreadsheet with four work sheets, each worksheet contains unique information, but the structure (columns/names) is 95% same, only a few filed were added to two of the worksheets.

       

      Use quick load, selected all worksheets, load the data.

      Created a new sheet, added a Bar Chart, added dimension and measure, applied filters to a specific value which occurs only in one of the worksheets 5 times, however the value presented in the bar chart 15 (3 times what should be)

      Open Data Modeler; find out that there are 3 tables. One of them contains the merger of all three. That is why the value in the bar chart shows 3 times what it should be.

      How can I eliminate the triple count?

       

      Thank you - Mauricio