How can the developer address this need with a LookML object?

A developer wants tocreate a measure that shows the item count broken out by category. When a second, more granular dimension is added to the same query, the count broken out by category should still represent the original aggregation and be duplicated on each line. The business wants this “count” in “category” available in the Explore section without any additional work done by the end user.

For example:

The Count column represents the count for each combination of Category and Item.

The Count in Category column represents the count for each Category only.

How can the developer address this need with a LookML object?
A . Create a measure filtered on Category, and make the filter value controlled by a parameter.
B . Calculate the measure using a derived table, and then join that derived table back into the Explore.
C . Create a measure with type: sum_over_dimension, and make the dimension value controlled by a parameter.
D . Calculate the overall count using table calculations in the Explore.

View Answer

Answer: B