I have a data set with ETL Date and Amount. Requirement is that when the user selects 2 different ETL Dates, it should give me the below:
-Sum(ETL Date 1) - Sum( Etl Date 2)
-Sum(ETL Date 1)
Sum(ETL Date 2)
I used the below expression to get the difference between 2 selected dates but it works only for a straight table with ETL Date as a Dimension. I need expression which can give me the above 2 requirements even in a KPI or Text Object.
Attached please find the sample app with the sample data