Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I use 2 Pivot on my dashboad. The user selects the period from the filters (Daily, Weekly, Monthly), if user wants can select a post-period date. The first pivot changes according to this selection. The 2nd pivot should write the previous value so that the selection can be compared. For example, if daily is selected today or selected day-1, if weekly is selected this week or selected week-1. My attempts did not work. It is a very urgent need, can anyone help?
if(GetFieldSelections([Period]='Daily'), vYesterday),
if(GetFieldSelections([Period],'Weekly'),vPreviousWeek)
if(GetFieldSelections([Period],'Monthly'),vPreviousMonth))))
//
if(Wildmatch(GetFieldSelections([Period],'Daily')'$(Yesterday)'),
if(Wildmatch(GetFieldSelections([Period],'Weekly')'$(Yesterday)')
if(Wildmatch(GetFieldSelections([Period],'Monthly')'$(vPreviousMonth)')
Hi
May be this
if(GetFieldSelections([Period]='Daily'), $(vYesterday)),
if(GetFieldSelections([Period],'Weekly'),$(vPreviousWeek))
if(GetFieldSelections([Period],'Monthly'),$(vPreviousMonth)))))
Thank you for your answer. Finally, I tried the one below, but the monthly one never works. I could not get the total of the previous month 😞
=if(GetFieldSelections([Period])='Daily',sum({<DATE= {'$(vYesterday)'}>} IPCOUNT),
if(GetFieldSelections([Period])='Weekly',sum({<DATE= {'$(vPreviousWeek)'}>} IPCOUNT),
if(GetFieldSelections([Period])='Monthly', sum({<MONTH= {'$(vMonthly)'}>} IPCOUNT)
)))
My Monlty variable is;
=Date(MONTH-31, 'DD.MM.YYYY')
I wrote above "sum({<MONTH= {'$(vMonthly)'}>} IPCOUNT) " works when I write 01.10.2023 instead of the variable in the formula. "sum({<MONTH= {'01.10.2023'}>} IPCOUNT) but it does not detect the variable value even though it is correct.