Hello Ashishp, 

Since you’re asking about subsets, I have a feeling you have experience working with Anaplan. First thing I want to point out is that Pigment does not have similar sparsity issues as Anaplan and therefore there is not the same kind of need for using subsets. 

However, one way you can achieve is by creating a property information into a dimension and using the FILTER-function in the formula. 

Here are example steps:

1. In a dimension, create a new property with boolean type. If you want to get fancy, you can setup a formula that will update the boolean or it can even be a list item. 

2. In a metric, use the FILTER-function
   1. In this case the metric “PUSH_Actuals_by_CC_Account_Vendor” has the following dimensions: Cost Center, Account, Vendor, Time
   2. Metric “MET_INP_Multiplier_Metric” has no dimension, so the same multiplier is applied for all cells
   3. Since I am using the FILTER-function only the Cost Centers with the boolean value are included and other Cost Centers will receive BLANK-value

As an additional tip, I suggest experimenting with using IN with the FILTER-function. I have found this especially useful when I have had to filter for example a certain set of account groups. 

Hope this helps :) 

Hi,

Thank you @Lehtohen , this is a very good solution, using booleans to create subsets is the right approach. You can even use a formula on your boolean property to determine the elements to keep or remove, making this subset dynamic!

I also wanted to add about the formula syntax, when you’re calling a boolean, you don’t necessarily need to write boolean = TRUE, because by defaut Pigment will consider only the true results when you call a boolean.

So your filter can just be : FILTER: dimension.boolean]

Hope you have everything to move forward @Ashishp !

Best,