1 Reply Latest reply on Feb 22, 2016 12:06 PM by ann.stolzman

    Adding date dimension to the column name

    jitan.chainani

      Hi Guys,

       

      I have a measure with the formula below and need to combine the date for last saturday to  this measure.

       

      Dimension for last Saturday - datetrunc('week',[Show Date]-1,"Saturday") show date is the parameter.

      Measure  - count(if [Date] = [Last Saturday] Then [Times] END)

       

      The formula works  fine, I just need to combine the dimension with measure name in column  header.

       

      Thanks,

      JC

        • 1. Re: Adding date dimension to the column name
          ann.stolzman

          Jitan,

           

          Have you tried creating a calculated field that combines the two?  Would str([Last Saturday])&" - "&str([Measure]) work?  Then you can hide the other headers, and this should serve the purpose you want.  Well, you might still have to adjust something with the text because of measure aggregation, but this should be a good starting point.

           

          -Ann-

          1 of 1 people found this helpful