Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Experts,
I need a help to resolve this problem
I have in Input in a pivot table
Applications Servers Months
A01 S1 Octobre-2012
A11 S1 Octobre-2012
A02 S2 November-2012
A03 S4 December-2012
A04 S2 January-2013
A14 S1 January-2013
A03 S1 February-2013
A01 S2 March-2013
I have to accumulate a number of distinct “applications” by month with a condition that is not accumulate “applications” if exist in previous month.
The expression I’m using is
RangeSum(Above(Count (distinct([Applications])),0,RowNo()))
Result provided
Months Cumulated different Numbers Of Applications by month
Octobre-2012 2
November-2012 3
December-2012 4
January-2013 6
February-2013 7 (a problem for me because A03 exist in December-2012)
March-2013 8 (a problem for me because A03 exist in October-2012)
And I want to have this result
February-2013 6 (because A03 exist in December-2012)
March-2013 6 (because A01 exist in Octobre-2012)
Thank you in advance for your help
résolu
Hi,
Find the attached file.
