Sum measure by dimension

sungyunley — Wed, 16 Dec 2020 02:13:05 GMT

Hi all,

I'm trying to create a 'dynamic' measure that sums 'Prod_MRR' based on the opportunity ID. At

I want to create a measure that rolls up the sum of 'Product_MRR' based on opportunity ID. It's worth noting that there are duplicate opp IDs because the table also lists the products attached to the opportunity. For example, opportunity A can have 3 product line items so that opportunity id of A will show up 3 times, but each product only once. In this example, the new measure would show the same value for all 3 records. My end goal is to take the individual 'Product_MRR' values for each row and divide it by the new summed measure to have a '% to Total' field. Last point to make, is i'd like to be able to filter on these product line items on the dash and the summed measure change with the filters.

I was thinking maybe a set analysis but i think i'd have to call out opp ID in order to sum to the opp level.

See screenshot for example. See oppid shows up multiple times, and PGD_MRR is different for each row.

Re: Sum measure by dimension

MayilVahanan — Wed, 16 Dec 2020 03:10:02 GMT

Hi @sungyunley

Try like below

Sum(Total<SFDCOPPID18> PGD_MRR) <-- would show the same value for all 3 records

% to Total : Sum(PGD_MRR)/ Sum(Total<SFDCOPPID18> PGD_MRR)

Re: Sum measure by dimension

sungyunley — Thu, 17 Dec 2020 00:43:00 GMT

That worked perfect, thank you!!!

topic Re: Sum measure by dimension in App Development

Sum measure by dimension

Re: Sum measure by dimension

Re: Sum measure by dimension