Get user Selected date previous day and next day data

1. Develop a report as shown
   
2. Create a variable prompt as shown
   
3. Click on preview select any date and observe output
   
4. 
   

Create Prompts on Hierarchy

1. Develop a report as shown below
   
   
2.  Go to Selection Steps ➔ under customers - CustomersDim ➔ Click on Edit
   
3. Select TotalCustomers move right side ➔ Enable Override with Prompt ➔ Click on OK
   
4. Click on prompts ➔ Column Prompts ➔ Customers hierarchy object as shown below ➔ ok
   
5. Click on preview select central and observe output