1 Reply Latest reply on Oct 29, 2019 12:59 PM by Ken Flerlage

    Use multiple Measures coming from Diff Tables in one KPI

    Surendra Peddabattigalla

      Dear Team,

       

      I have requirement like i have 3 tables Yearly table,Monthly, Original Transaction Table and have 5 global filters(Year,Month,Week,Country,Region).

       

      If user passes  year selection value then we need to display measure from yearly table

      If user passes  Month selection value then we need to display measure from Monthly table

      If user passes other than (Year/Month) like country, week etc selection value then we need to display measure from Original Transaction table.

       

      could you guys please help me how to create single calculated field to display data in one KPI based on user selections.

       

      Thank you.