2 Replies Latest reply on Jun 8, 2018 1:29 PM by Shinichiro Murakami

    Help Creating New Measures with Strings from Dimensions

    richard glasser

      Hi -


      I would like to separate my Budgets and Actuals that are coming in from my data source under one column.


      I would like to create a viz that shows my Actuals, then Budgets, and then a variance of remaining amount and want to do that by creating two calculated fields, one for Actuals and one for Budget and then dividing them to get the remaining amount.


      Please find attached for the workbook and data.


      Thanks in advance!