Solved: Re: how to sum multiple rows below - pivot table - Qlik Community

Report Inappropriate Content · ‎2014-04-09

I need to make a table with the total billed value on YearPeriod x

this is a start, i need to translate this afterwards in payed days in adition to the costs (work in progress)

how can i create Wanted Value?

Report Inappropriate Content · ‎2014-04-14

rangesum

(
below(
sum( {$<
YearPeriod= {">=1900001"}
>} WIP)*-1,
0,
noofrows()-rowno())
)

found it out, solution was on : noofrows()- rowno()

Report Inappropriate Content · ‎2014-04-14

rangesum

(
below(
sum( {$<
YearPeriod= {">=1900001"}
>} WIP)*-1,
0,
noofrows()-rowno())
)

found it out, solution was on : noofrows()- rowno()

how to sum multiple rows below - pivot table