I have a data for monthly prepaid subscription of a tool, I need to add a user input field in report wherein the user would enter two months he/she would like to compare, to show the net new subscribers in latest month of the two months entered, as well as the subscribers from the earlier month of the two months who haven't renewed in the latest month and the subscribers present in both months.
The solution works perfectly, but I need the Customer No. for furthur Drillthrough to show details of New/Lost Customer. So is there any other way to get results of comparison in listed format(to use in table visualization), from which I can right click on Customer No. and drillthrough to details.
I've shown only three columns of the original dataset in sample data, whereas my dataset has many more columns(username, address, contact information and other personal information).
In my report I'm having a customer detail drillthrough page with all available details about customer, which can be accessed by right clicking on Customer No. and then click drillthrough. So in any Visualization or chart in my report i can right click on Customer No. and drillthrough to Customer details page.
But in solution you have used the concatenate function and card visualization, which does not support drillthrough.
I need to display the comparision results in list or tabular format, then i can select a single coustomer and drillthrough to the Customer details page.
Sorry, I can't share more column details as it contains personal infromation.