3 Replies Latest reply on Jun 28, 2018 2:31 AM by Amit Narkar

    Filter using values from secondary data

    Kamili Dabrowski

      Hi Guys,

       

      What I am trying to do is to give a user option to show Top 10 customers based on Parameter (Profit or Quantity). Profit is coming from first database and Quantity from the second. In primary database I have created field "Top (Measure)" that shows the value of chosen metric. Now I would like to show in the sheet Top 10 "Top (Measure)" accounts, but I can not. Do you now any work-around for that?

      In my real workbook, because of the number of records and complexity (AR, Revenue, Disputes, etc.) it is impossible to keep all this data in ona database and I had to split that into few and create calculation fields.

       

       

      Thanks in advance,

      Kamil