found % for each field in the column from the the particular field in column

[kolov007]

I want to find the share of each budget items by cost. As in the example below

I'm trying to use Set Analysis, but I get the following

Help me please.

[oknotsen]

Try this:

sum([budget items]) / sum(TOTAL [budget items])

[sunny_talwar · Accepted solution]

Try this:

sum(totalsum)/sum(TOTAL {<[budget items] = {'cost price'}>} totalsum)

[oknotsen]

Yeah, I think Sunny is a bit closer to the solution than my initial suggestion.

[Kushal_Chawda]

Create the variable on front end

vCost =sum({<[budget items] = {'cost price'}>} totalsum)

Now write the expression

=sum(totalsum)/$(vCost)