2 Replies Latest reply on Aug 9, 2018 4:57 PM by Patrick A Van Der Hyde

    Text column next to measure names and current month as FY

    nataraj.vijayanagaram

      Hello Experts,

       

      I am looking for some help for creating a view. I want to create a view like the below:

       

      Challenges:

      • Adding description column next to measure names list.
      • Add FY column with the latest value in the dataset by month.

       

      Group NameDescriptionFebMarAprMayJunJulFY 2018
      QuantityDescription for Quantity363885733887931840840
      DiscountDescription for Discount18%13%19%15%17%14%14%
      Number of RecordsDescription for Number of Records107238203242245226226
      ProfitDescription for Profit $        1,614 $      14,752 $           933 $        6,343 $        8,223 $        6,953 $       6,953
      SalesDescription for Sales $      20,301 $      58,872 $      36,522 $      44,261 $      52,982 $      45,264 $     45,264
      Profit RatioDescription for Profit Ratio8%25%3%14%16%15%15%

       

      Can someone please advise how to achieve this.

       

      Thank you!