2 Replies Latest reply on Nov 19, 2013 2:23 AM by john.finn

    On Hand being multiplied by # of sales records

    john.finn

      Hi,

      New Tableau user and I have run into an issue I can't seem to resolve...

       

      I have Data Source 1 which includes Store, Date, Item#, Qty Sold, SalesValue etc

       

      Data Source 2 contains Store, Item, OnHand.   The datasources are linked via ITEM#.

       

      When I use date range for viewing sales the figure for SOH gets multiplied by the #of sales rows for each item.

      E.G. Item 1 has sales on 1st October, 2nd October, 5th October and 6th October. The OnHand figure then gets multiplied by 3 when I use date range 1st Oct t

       

      Any thoughts please on how I can overcome this?