2 Replies Latest reply on Mar 8, 2018 5:40 AM by Jim Dehner

    Need to show one measure values for two different quarters

    Anandh V

      In the below scenario i have two cases

      1. when i select year quarter i have different sales values

      2. when i select fiscal quarter i have different sales values

       

      Actually i need to show both the values in one selection itself .

      Suppose if i am using YQ i need to have the Fiscal qtr sales as well in the same sheet.

      Here you can both the values are different based on selection.

       

      In dashboard i need to use Year Qtr as filter but i have to display both Year Qtr and Fiscal Qtr sales values in same sheet one below other.

      I have attached the test workbook and data as well.@