Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hai all,
i have data like region quarter value, is there below is my requirment
Req : the pivot table should show the result for from current quarter to till futer quarters avaiable in data
means: current quarter 2018Q4 to - 2030Q3 ( old quarters data should not sum /count in the result table)
Thanks
Sony
Shouldn't this be like:
num(sum({<SERVICE_TYPE={'Hardware'},Fiscal_Period={"=Fiscal_Period >Year(Now())&'Q' & Ceil(Month(Now())/3) and Fiscal_Period <=Year(Now()+120)&'Q' & Ceil(Month(Now()+4)/3)"}>}Value)/$(vFormatId),'##.00'),
thank you its working have a nice day
Hi franky_h79
all of sudden it shsowing 5 qtrs in my chart could you please look into this
if i add quarter into table i can see 5 quarters what might be the issue?
sir Frank Hartmann can you check this?
you want to show only 4 quaters or including the 'Beyond'......quarter?
one table is 4 qtr +beyond quarters its working fine,
but only 4qtrs tables is showing 5 quarters it should show current quarter and next 3 quarters
2018Q4,2019Q1,2019Q2,2019Q3
check the attached qvw in that i want to show only above requirment
check attached qvw!
thank you so much sir