3 Replies Latest reply on Apr 1, 2018 12:11 PM by Norbert Maijoor

    create a new dimension

    Vijay Alluri

      Hello,

       

      can you assist with the below question:

       

      I have a dimension with the following data as below with various measures tied to it like sales, costs etc. how can I create a calc field to break down the dimension into desired values. For example, I want a dimension which shows only the last quarter of the data which is FY19Q1 and another dimension to show the value prior to it. Finally, my goal is to create dimension using calculated fields to identify the latest quarter, prior quarter etc. Can the level of detail expression help with this problem?

       

      Fiscal Quarter

       

      FY18Q1

      FY18Q2

      FY18Q3

      FY18Q4

      FY19Q1

      FY19Q2

       

      As per the workbook attached. I can calculate the current quarter based on the current quarter flag field which is available in my original data source, how can I calculate the value for "previous quarter" field to be FY18Q4 for the dimension "Previous Quarter" in this given scenario.

       

      Please find attached the workbook. thanks !!