Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Folks,
I have a data, for that i want to show Previous Quarter Data.
Measure Expr:-
If(GetSelectedCount(Quarter)=0,
Count({<QuarterNo={$(=Max(QuarterNo-1))}>}Fdbk_Typ),
Count(Fdbk_Typ))
Header Expr:-
'Total Survey Response' &' ' &
If(GetSelectedCount(Quarter)=0,
Only({<QuarterNo={$(=Max(QuarterNo-1))}>} Quarter),
GetFieldSelections(Quarter))
Its showing only data available Quarter. As below attached "Samsung " don't have data for Previous Quarter. So simply i want to show as 0.
Can any one help wit this..
Sub2u444
May be this:
Alt(
If(GetSelectedCount(Quarter)=0,
Count({<QuarterNo={$(=Max(QuarterNo-1))}>}Fdbk_Typ),
Count(Fdbk_Typ)), 0)