3 Replies Latest reply on Oct 23, 2017 12:45 PM by Sherwood Neiss

    LOD question ... probably an easy one

    Sherwood Neiss

      I track companies that are raising money. Each company raises capital each day. Each company has a disclosed Maximum Offering Amount. In excel I can just sum the Maximum Offering Amount on the Master tab. However in Tableau it is all merged. I've tried to do a LOD formula to fix each company (Org_id) and then sum Maximum Offering Amount by just doing this  {FIXED [Org Id]:sum([Max Offer Amount])} but it just takes the Max Offering Amount on each line and sums them all up ... which in essence is duplicating the max offering amount based on each day a company raises money.

       

      After 2 days of trying I thought I'd ask the forum. Attached is the excel spreadsheet. I also uploaded it to tableau public: Tableau Public