5 Replies Latest reply on Feb 10, 2016 5:35 AM by Adam Crahen

    Display values in text based on certain dimensions

    kris ma

      I have a worksheet with the following fields: [Sales], [Units], [Year], [Sales % Difference from Previous Year] in the marks section. I have the YEAR(Date) and [Sale Type] fields in the rows section. I want to have the text section with a short paragraph that show values based on different dimensions. For example, I want to say something like


      In 2015, overall sales totals were ([Sales] WHERE Year = 2015) compared to ([Sales] WHERE Year = 2014), a ([Sales % Difference from Previous Year] WHERE Year = 2015). Internet sales for 2015 totaled ([Sales] WHERE Year = 2015 and [Sale Type] = 'Internet')...etc.


      Is this possible and if so, how can I do it?