current to future only

[soniasweety]

Hai all,

Tresesco B

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

[tresesco]

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'),

[soniasweety]

thank you its working   have a nice day

[soniasweety]

Hi franky_h79

Felip Drechsler

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?

[soniasweety]

sir Frank Hartmann  can you check this?

[Frank_Hartmann]

you want to show only 4 quaters or including the 'Beyond'......quarter?

[soniasweety]

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

[Frank_Hartmann]

check attached qvw!

[soniasweety]

thank you so much sir

[Frank_Hartmann]

what about here:

Separate bar

any further problems? or can you close the thread?