1 Reply Latest reply on Jul 4, 2018 3:47 AM by Mavis Liu

    Show grand total and filtered total in one table

    Mark Thomson

      Lets say I have the following values


      Vendor AAA, Costs 100


      For Vendor AAA we have


      Business XXX who pays 60

      Business YYY who pays 40


      On a table I am showing


      Vendor   Total

      AAA        100


      When i used filter on business set to say XXX I get


      Vendor Total

      AAA      60


      When i filter for a business (e.g XXX) i want to see


      Vendor Total  VendorTotal  %ofTotal

      AAA      60     100                60%


      If i filtered for YYY I would logically get

      Vendor Total  VendorTotal  %ofTotal

      AAA      40     100                40%


      If i removed all filters I would get

      Vendor Total  VendorTotal  %ofTotal

      AAA      100     100                100%


      Any help would be appreciated... been stuck on this for weeks.