Lookup Function Creation?

Lookup Function Creation

Lookup Function Creation?

Explanation

1. In general we are using lookup function for the Comparison purpose,. Like Year over Year comparison based on the sales.

2. Drag Order Date into Rows.

3. Create calculation for Lookup function for previous year, as shown below.

Lookup Function Creation
4. And create a calculation for Year over Year sales comparison. As shown below.

Lookup Function Creation
5. Now drag the measure names into Columns. And right click on that field and select sort option then it will open the sort window.

6. In that select sort Type as Ascending order and give the Sorting manually, as shown below.

Lookup Function Creation
7. Now drag the measure Names into Filter self and select the Sales and YOY sales Growth then click on apply and then click on OK.

8. Now drag the measure values into Text at marks card level.

9. Measure values are shown below the marks cards. In that right click on the YOY sales Growth and select ‘add table calculation’ and select the fields as shown below.

Lookup Function Creation
10. The visualization will display the YOY sales growth percentage, as shown below.

Lookup Function Creation

Leave a Reply

Your email address will not be published. Required fields are marked *