Difference/Trend based on Month(s) field - Retention
I have the following Data model with the fields:
Month
Customers
MonthCustomers
Jan 200
Feb 150
Mar 170
Apr 220
. .
. .
Dec 80
I need to provide users option where the users can select any month or months and the difference between the selected month(s) and the remaining months should be populated.
For example, if the user selects Jan, the following output should be seen
MonthCustomers Difference
Jan 200 0
Feb 150 50
Mar 170 30
Apr 220 -20
. . .
. . .
Dec 80 120
The user should be able to pick any month or months instead of Jan, dynamically and based on the selected month, the Difference column should be calculated.
When I create the alternate state, assign it to the list box, the values in the column show up correct. But after I reopen the document, or add other objects or even try to change the sheet and come back, the column shows incorrect values.
As soon as I create the alternate state, assign it to the list box and create an expression in the chart, the resultant column shows right values. But once I make other selections or clear selections and make the same selections in the list box, the values are messed up. I have to create a new alternate state and assign it again in order to see the correct values. Even that shows the same issue after clearing out the selections and picking them again.
Pradosh, I have another column called Users that contains all the Users.
My Requirement is
1. When I select the month, I should see the values in the column only for the subsequent months. Meaning, if I select Mar, I should see the result values from Mar or Apr but not the previous months.
2. I also need to check what users are present in the Selected month and the remaining months and show the Result.
For example, when March is selected, the resultant column should show only those Users that are common in March and the remaining months respectively.
Pradosh, I have another column called Users that contains all the Users.
My Requirement is
1. When I select the month, I should see the values in the column only for the subsequent months. Meaning, if I select Mar, I should see the result values from Mar or Apr but not the previous months.
2. I also need to check what users are present in the Selected month and the remaining months and show the Result.
For example, when March is selected, the resultant column should show only those Users that are common in March and the remaining months respectively.
