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 tour help.
I am working on this exact same issue. Anybody have an idea on this?
I am counting distinct values over time but in the accumulation it is not discounting the distinct values from the previous months in the selection.
Hi Aaron,
I found a formula to count the values do not included in the previous month:
if (count(Period_MonthName)>1, MinString(Period_MonthName),Period_MonthName)
But I don't know how to transform this expresion to dimension! Do you have an idea?
Best regards.
