I have previously looked at EXCLUDE LODs in this blog.  Today I am going to show you another LOD calculation and how they are formed and their use case.

The FIXED LOD is the same as the EXCLUDE (and the other LOD INCLUDE) in their format. You can type them out from creating a calculated field:

{FIXED [Dimension]: (Aggregate Measure)}

Top tip: Drag the dimension you wish to use to the measure you wish to aggregate while holding ctrl and it will automatically create LOD calc. Similarly, you can hold ctrl and select the dimension and measure and then right-click one of those and go to create>LOD Calculation which is under the usual ‘Calculated Field’ option.

Right, now we know how to make our FIXED LOD let’s choose a measure we want to aggregate and a dimension we want to ‘fix’ it at.

I’ll use superstore data for this and want to show the sum of sales by category and by subcategory in the same worksheet at different levels of detail.

So, to begin let’s drag Category and sub-category into the viz on rows and sales to columns. Then we are going to make our LOD using one of the methods described above.

It should look like this:

{FIXED [Category]: Sum(Sales)}

Once this is done drag measure names to columns and filter and select only the [sales] and [sales category LOD] drag measure values to text and you will see this view.

 

 

There you have it you now have the two levels of detail Category and Sub-Category on the same visualisation.

The Data School
Author: The Data School