Calculating the Percent of Total using LOD Function.

Calculating the Percent of Total using LOD Function.

Explanation

1. Drag Sales into Columns.

2. And again drag sales into columns. And Right click on that and select the Edit in shelf option, in that use the LOD calculation on sales. As shown below.

{SUM (Sales)}

Then press enter. Now it is showing in the SUM ({SUM (Sales)}).

3. Drag Country into Rows and right click then select sort option in that sort select sort on Descending order and sort by field as sales and aggregation as SUM. As shown below.

Calculating the Percent of Total using LOD Function.
4. Now create a calculated field for Percent of Total, as shown below.

SUM (Sales)/MIN (SUM ({SUM (Sales)})

5. Then it will give the percent of total on each Country wise sales.

6. Drag Market into Filter then select EU only then click on apply and then click on OK.

7. Then right click on the Market at filter shelf and select Show filter.
8. And select the chart type as bar at marks card level. The visualization looks like below

Calculating the Percent of Total using LOD Function.

9. Now select the new sheet.

10. In this sheet I am going to show the geographical fields.

11. Drag Longitude (generated) into Columns.

12. Drag latitude (generated) into Rows.

13. Drag Market into filter shelf and select EU.

14. Drag Percent of Total into color shelf at marks card level.

15. Drag Percent of Total into Text at marks card level. The visualization looks like below.

Calculating the Percent of Total using LOD Function.

Leave a Reply

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