How to get Non Cumulative count

[Buchannagari]

Hi ,

I have a pivot table

It is having Measure Males planted and for that i wanted to show cumulative count ---->RangeSum(above(sum([Males Planted]),0,RowNo()))

So, now i wanted to show non cumulative count by using cumulative count measure if i don't have Males Planted measure

Please help here to get it

Regards,

Buchannagari.

[vinieme12]

What exactly are the expected values? 

for

Week9

Week10

Week11

[Buchannagari]

Hi,

WEEK 09 is 0

WEEK 10 is 641.47[(WEEK 10-WEEK 09)]

 WEEK 11 is 392.19[(WEEK 11 -WEEK 10)]

The measure' Males Planted' is having non cumulative count (This the output we want)

But here i don't want to use that Males Planted field from the data 

By using 'Cumulative Males Planted Running Total' field we need to get that 'Males Planted' values

Regrads,

Buchannagari.

[vinieme12 · Accepted solution]

use Above()

https://help.qlik.com/en-US/sense/May2022/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/InterRecor...

=RangeSum(above(sum([Males Planted]),0,RowNo())) - above(RangeSum(above(sum([Males Planted]),0,RowNo())))

[Buchannagari]

Thank you...