
1. Re: Populate row values with a single value on hierarchy expansion
Shinichiro Murakami Jan 23, 2017 9:37 PM (in response to Justin Pulley)Hi Justin,
I don't know your original data format, then I assume below.
[Capex]
if [Category] ="Capex" then [Value] end
[PO Amount Value]
if [Category]="PO Amount" then [Value] end
Because PO# has duplicated row and unique ID is only amount, I needed add "[PO Amount Dimension]" to explode by amount.
[PO Amount Dimension]
[PO Amount Value]
[Percent 1]
{fixed [PO Number]:sum(if [Category]="PO Amount" then [Value] end)}/
{fixed [PO Number]:sum(if [Category]="Capex" then [Value] end)}
[Percent 2]
{fixed [Project Number]:sum(if [Category]="PO Amount" then [Value] end)}/
{fixed [Project Number]:sum(if [Category]="Capex" then [Value] end)}
[Percent 3]
if (sum([PO Amount Dimension]))>1 and sum([Capex]) >0 then attr([Percent 2])
elseif (sum([PO Amount Dimension]))>1 then attr([Percent 1])
end
Crate hierarchy with [Project Name], [PO Number] and [PO Amount Dimension]
Thanks,
Shin

Hierarchy_SM_9.0.twbx 11.5 KB
