4 Replies Latest reply on Sep 26, 2017 9:21 AM by John Sobczak

    Comparing row level data to aggregates

    Tyler House

      I have a data set in which each row is certain activity of a bank. I'd like to be able to create a bar chart that compares a single banks activity to the rest of the market. To do so, i created an calculation that will basically identify all rows that are the banks and all that are not, but I'd like this to be dynamic in the sense that a user could select the bank they want to compare to with a drop down menu without filtering the entire data set. I cannot do a parameter because the full data set has about 6,000 banks. Does anyone know how to do something like this?

       

      Here is the calculation i currently use: