Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Like adding 2 columns, hiding in the column "Month", the reference "Overhaul ', to bring me the percentage?
Sum columns [Maint.] = {'Planned'} <> [Mês] ('Overhaul') [TotalPrice)/Sum columns [Maint.] = {'Planned','Unplanned'} <> [Mês] ('Overhaul') [TotalPrice)/
Try
=
Sum ( {<[Maint.] = {'Planned'} , [Mês] -= {'Overhaul'} >} [TotalPrice])
/
Sum ( {<[Maint.] = {'Unplanned','Planned'} , [Mês] -= {'Overhaul'} >} [TotalPrice])