3 Replies Latest reply on Oct 14, 2018 12:57 AM by Chandrakant Gaur

    Finding Min and Max values with reference to next level segmentation in data

    Chandrakant Gaur

      Hi, I have a data table where there are 2 campaigns and 4 sub-campaigns. When I am creating a text pivot on Campaign level I want to see the Min and Max date that we have in all of the sub-campaigns.

       

      In 2nd snip I want only one date i.e. the minimum date for campaign level, which is 31st Dec in this case for 1st campaign and 27th Dec for 2nd campaign.