Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Team,
Am trying to get the last month value to show under KPI title which is taken from the excel file. But now the KPI shows the total from Jan to Dec, wherein I want to show only the last Month data and not sum.
Data is rolling totals
Below is the current expression, and have a variable for previous month. So can you please help me with the query to show last month value as 3.
current expression --- sum( {<RowType={'Other Activity'},[Other ActivityType]={'Consultant Trainings'}, [_KEY_DATE]={">=$(vYTD_DateFrom) <=$(vYTD_DateTo)"} ,YEAR=,MONTH=,Quarter=>} ActivityValue)
Previous month variable --- vPreviousMonth
Please help
Hi @MPS ,
try this one:
sum( {< RowType = {'Other Activity'}, [Other ActivityType] = {'Consultant Trainings'}, MONTH={"$(=Month(Today())-1)" } >} ActivityValue )
Best Regards
@MPS may be this
sum( {<RowType={'Other Activity'},[Other ActivityType]={'Consultant Trainings'}, [_KEY_DATE]={">=$(=monthstart(max(_KEY_DATE),-1)) <=$(=monthend(max(_KEY_DATE),-1)) "} ,YEAR=,MONTH=,Quarter=>} ActivityValue)
Unfortunately, both expression resulted the values to zero. Not sure if i am missing anything to do.