4 Replies Latest reply: Oct 24, 2016 8:03 AM by Nina Iren Jensen RSS

    Show selected dimension in Subtitle

    Nina Iren Jensen

      Hi

       

      Is it possible to show the selected dimension in the subtitle of another table?

      I would like to show the following in the subtitle for Selection as below;

      If Date from-to is selected: From 1/1-16 to 3/1-16

      If Week - Year is selected: Week 1-2016

      If Month - Year is selected: Month Jan-2016

       

      I managed to get one date or month by using

       

      =if(CalDate,'Period' & ' ' & CalDate,'Period' & ' ' & MonthYear)

       

      but as soon as I choose several dates it changes to MonthYear, and I am not able to set the expression for having Week-Year as a third option.

       

      This is correct since only one date is selected.

      Date.jpg

      This is correct - MonthYear is selected

      Month.jpg

      Here it should say From 1/1/2016 to 4/1/2016

      Month1.jpg