1 Reply Latest reply on Oct 6, 2018 4:03 AM by Jim Dehner

    Display static value and display date in table without any aggregation based on end_date selection

    Nandha Kumar Murugesan

      I have data below table like this



      What i tried below like this but getting summed

      I am trying to get the static value based on the country a,b,c meantime it gets aggregated due to measure


      Goal was on getting the table like below

      To get the static rate based on the selected end date and display the selected end_date in a row.

      I have also attached sample workbook data containing 3 dates  only 1/1/2018,2/1/2018,3/1/2018


      Based on End Date selection in table i would like to get a table like above.


      Is there any way to get this in a table based on selection of date.

      or any alternative in achieving this.