Hi, I am wondering if anyone has metric advice for me? I am attempting to create a metric that calculates the % of something over a larger category (%) in below. Asset Class Sub Type Units % Fixed Income Asset Backed 100 0.083333333 Fixed Income Corporates 150 0.125 Fixed Income Agency 200 0.166666667 Equities Common Stock 125 0.104166667 Equities Mutual Fund 250 0.208333333 Other Private Loans 275 0.229166667 Other Mortgage Loans 100 0.083333333 The issue I am running into is as soon as I filter down to fixed income, it recalculates the % to respect the parent filter: Asset Class Sub Type Units % What I see % Fixed Income Asset Backed 100 0.083333333 0.222222222 Fixed Income Corporates 150 0.125 0.333333333 Fixed Income Agency 200 0.166666667 0.444444444 My approach at first was a metric like this: select sum({fact/Units} ) / (Select sum({fact/Units) by {label/date.month}, all other) I then tried again using the WITHOUT PF but it looks to apply to both the numerator and denomenator

Hi Alex, Where exactly are you applying the WITHOUT PF? It seems like you may need to break percentages down in individual metrics and then apply another division between those.

Thanks @Joseph Heun,