3 Replies Latest reply on Jul 6, 2015 2:13 PM by Petr Romanov

    Creating a conditional textbox

    Petr Romanov

      I've added an aggregated column to the Superstore Sales spreadsheet in which we assign 1 for when the customer is Jim Radford, Don Jones or Frank Price.  0 otherwise. 


      Now, in the dashboard for Sales throughout Time with Customers as the Filter,  I would like to display a textbox informing the user that this customer has been Aggregated (if Aggregated = 1).  I would like to hide this textbox if the customer hasn't been aggregated. 




      For my actual purposes, for any given customer, only some of the years will have Aggregated = 1 (whereas other years won't).  Nevertheless, I would like to display a textbox (or perhaps it would be a legend) whenever any of the years have aggregated = 1 for a chosen customer.