Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have month year column.
I need to aggregate value for all month year having value > 12 month, I am using dimension as per below please suggest.
=If(Date(AR_CustomerLedger.MonthYear, 'MMM-YYYY') >= Date(AddMonths(Today(),-11), 'MMM-YYYY'), Date(AR_CustomerLedger.MonthYear, 'MMM-YYYY'), '> 1 Year')
Hi Sunny,
The total results in >1 year column in 1 year drop down selection and > 1 drop down selection total in chart is not matching.
and in latest app 3 month , 6 month, 9 month,12 month not showing as per need
Thanks
I am not sure what you want Deepak... Unless you can clearly provide me the expected output... I might not be able to help you brother....
All the best
Hi Sunny,
As shown in above image attachment the view for 1 year drop down selection in list box.(having >1 year column)
Fot 3 month, 6 month , 9 month , 12 month drop down selection in list box need to show previous 3,6,9,12 month resply.
For > 1 year view need to show those month like
Sum({<AR_CustomerLedger.MonthYear ={"*"}-{">=$(=Date(addmonths(Max(AR_CustomerLedger.MonthYear), -11), 'MMM-YYYY'))"} >} AR_CustomerLedger.OpenAmount_Resolver) this
Total in >1 year view and > 1 tear column in 1 year view should match.
Thanks