Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
Given a Year and month selected, How could I get the Count number of days for each Year/Month selected in a pivot table?
The expected value is in column "Count Days"
The result should be like this
Please help
Thank you
Hi @Barry-Gon , your second expression should be like this :
=Sum(total <Año> Aggr(Sum(DISTINCT Day(MonthEnd(InicioDelMes))),InicioDelMes))
Hi @Barry-Gon , your second expression should be like this :
=Sum(total <Año> Aggr(Sum(DISTINCT Day(MonthEnd(InicioDelMes))),InicioDelMes))
Thank you @QFabian it works perfect! 😀